[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: PostgreSql Version



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