You have to upgrade to postgres 7+
subselects are not supported in pre 7 versions.
Dieter Simader http://www.sql-ledger.org (780) 472-8161
DWS Systems Inc. Accounting Software Fax: 478-5281
=========== On a clear disk you can seek forever ===========
On Wed, 20 Feb 2002, Craig Nunemaker wrote:
> I checked psql and neither worked. After doing some reading on postgresql, I noticed
> single quotes. The following worked in psql:
>
> SET DATESTYLE to 'ISO'
>
> I edited my user.conf in the dboptions line to use single quotes. It worked.
>
> However, now my AR and AP module give me the following parser error when trying to
> Add a Transaction.
>
> SELECTcurrent_date AS transdate, current_date + 30 AS duedate, d.curr AS currencies,
> (SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id) AS fxgain_accno,
> (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno
> FROM defaults d
> Parser error at or near "select"
>
> I ran it piecemeal through psql and ran into problems at the subquery.
>
> BTW, I am using a Debian Woody default installation with Perl DBI.
>
>
> 2/19/02 1:27:33 PM, Dieter Simader <dsi...@sq...> wrote:
>
> >Hi Craig!
> >
> >load psql and type in
> >
> >SET DATESTYLE to ISO
> >SET DATESTYLE to "ISO"
> >
> >let me know which one works.
> >
> >
> >Dieter Simader http://www.sql-ledger.org (780) 472-8161
> >DWS Systems Inc. Accounting Software Fax: 478-5281
> >=========== On a clear disk you can seek forever ===========
> >
> >On Mon, 18 Feb 2002, Craig Nunemaker wrote:
> >
> >> Has anyone ever gotten a DateStyle parse error?
> >>
> >> After logging in and clicking on any module action the screen displays the follwing
> error:
> >> Error: Set DateStyle to "ISO"
> >> Parse error at or near ISO
> >>
> >> I checked my Apache error log and found the following entry.
> >> DBD::Pg:db do failed: ERROR: parse error at or near "iso" at SL/Form.pm line
> >> 431
> >> Error: set DateStyle to ISO<br>ERROR: parser: parse error at otr near "iso"
> >> Database handle destroyed without explicit disconnect.
> >>
> >> I examined SL/Form.pm but could not figure out how the code itself would raise an
> error.
> >>
> >>
> >>
> >>
> >>
> >>
> >> NOTICE: When replying, please Reply to the list address. This way other members
> know if the issues have been resolved or not. Thanks! Your List administrator.
> >>
> >>
> >
> >
>
>
>
>
|
