Re: PostgreSql Version

["Chris Travers" <..hidden..>]

Hi Alejandro;

If you are on Linux, run the following command in the ledger-smb/sql directory:

sed -i -e 's/ALSO //' Pg-tables.sql Pg-upgrade-2.6.17-2.6.18.sql

Also, I think that there were some data corruption bugs in 8.0 that
were corrected in later 8.0.x releases.  if you have not done so, you
should upgrade to the latest 8.0.x.  This does not require a
dump/restore.

If this works for you, I may release another maintenance release for
1.1.1 with a few other changes (including the documentation points you
have brought up).

Best Wishes,
Chris Travers

On 9/25/06, Chris Travers <..hidden..> 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
> >