Re: PostgreSql Version

[Alejandro Imass <..hidden..>]

Nop. This is using the normal admin.pl interface. Once I select the
database, multibyte encoding and COA and click continue. I thought it
had to do with my pg version which was 7.4 (7.4 does not support "ALSO"
in the rules), but I just installed pg 8.0 and get the same error.

Thanks for any help you can provide. As promised, this is my first
migration from SL to LedgerSMB (in my wife's personal machine!, you can
imagine the tension... ;-) ). Note that is a fresh install test it out
before I attempt an actual migration.

Best,
Alejandro Imass

On Mon, 2006-09-25 at 12:18 -0700, Chris Travers wrote:
> Wow.  I have never seen that error before.  Does the error occur when
> you run the Pg-tables.sql script in psql?  We have noticed some odd
> issues with the way db scripts are currently handled.
> 
> 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