SOLVED! (was: Re: PostgreSql Version)

[Alejandro Imass <..hidden..>]

Chris and all, thanks for your kind replies.

The culprit was a clumsy Ubuntu upgrade from PostgreSql 7.4 to 8.0 . I
de-installed 7.4 and after installing 8.0, part of the installation was
pointing at the 7.4 data dir! I was tipped from your mail by running the
db script directly from psql and I noticed ledger-smb and psql where
looking at different db lists! 

Here is how I fixed it:
I de-installed both versions, cleared all the directories, config files,
etc. and re-installed a fresh pg 8.0. BTW, It seems the "postgresql-8.0"
packages are broken in Unbuntu 5.6 because I had to manually initialize
the cluster and create the init.d scripts by hand. I think it's because
the "postgresql" (base pkg, which I am speculating contains the init.d
scripts) is transitional and still for 7.4. 

Good thing I had backed up all the databases before messing with this!

As I stated in a previous mail, I think the pg 8.0 move will
definitively have an impact on Debian users (specially "stable" users).
If any other Ubuntu / Debian users may have these problems they can talk
to me and I can walk them through this upgrade, or try to guide them as
to how to have pg 8.0 on a stable dist by doing "apt-pinning".

Everything seems to be working fine now!

Thanks again,
Alejandro

On Mon, 2006-09-25 at 12:43 -0700, Chris Travers wrote:
> Also, can you provide more information about your environmnet:
> 
> 1)  Am I right in assuming that this is 8.0 and not a later 8.0.x version?
> 2)  Which OS are you using?
> 
> DO ALSO syntax was first introduced in 8.0.  So I am wondering if
> something else is going on here.  I will be taking out the ALSO since
> it is not specifically necessary.
> 
> I will try to reproduce your issue but I built most of these rules
> first on 7.4 and so they really should be working.  Occasionally some
> bug does surface regarding rule creation, but that is pretty rare
> (last time I ran into one was a bug that caused back-end crashes on
> something like 7.1.3 or something).
> 
> Best Wishes
> Chris Travers
> 
> On 9/25/06, Alejandro Imass <..hidden..> wrote:
> >
> > Ok, thanks for your prompt reply. I downloaded from SF.net and did not
> > see this, also please note that release_notes, README and VERSION need
> > updating. VERSION still says 1.1.0 (on 1.1.1), README still says
> > PostgreSQL 7.1, and release_notes still says 1.1.0 (although the pg v8
> > is correct there).
> >
> > I installed pg 8.0 and still get this error when creating the Database:
> >
> > CREATE RULE ap_id_track_i AS ON insert TO ap
> > DO ALSO INSERT INTO transactions (id, table_name) VALUES (new.id,'ap')
> > ERROR: syntax error at or near "ALSO" at character 50
> >
> > Any ideas?
> >
> > Thanks,
> > Alejandro Imass
> >
> > On Mon, 2006-09-25 at 14:08 -0400, Christopher Murtagh wrote:
> > > On 9/25/06, Alejandro Imass <..hidden..> wrote:
> > > > I searched the lists archives as best I could with advanced searching
> > > > such as postgres + version, or postgresql + version, etc. and did not
> > > > seem to find any threads regarding PostgreSql version and LedgerSMB.
> > >
> > >  LedgerSMB supports Postgres 8.x only. We debated on whether we should
> > > include 7.x support in IRC, and the conclusion was no. This was then
> > > put up on the website here:
> > >
> > > http://www.ledgersmb.org/download/
> > >
> > > Cheers,
> > >
> > > Chris
> > >
> > > -------------------------------------------------------------------------
> > > Take Surveys. Earn Cash. Influence the Future of IT
> > > Join SourceForge.net's Techsay panel and you'll get the chance to share your
> > > opinions on IT & business topics through brief surveys -- and earn cash
> > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > > _______________________________________________
> > > Ledger-smb-devel mailing list
> > > ..hidden..
> > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
> >
> >
> > -------------------------------------------------------------------------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share your
> > opinions on IT & business topics through brief surveys -- and earn cash
> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > Ledger-smb-devel mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
> >
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel