Re: Bug #757: ODBC Doesn works - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Bug #757: ODBC Doesn works
Date
Msg-id 20020904143928.E60532-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Bug #757: ODBC Doesn works  (pgsql-bugs@postgresql.org)
List pgsql-bugs
On Wed, 4 Sep 2002 pgsql-bugs@postgresql.org wrote:

> Long Description
> I have Postgresql 7.2.2 in a red hat 7.3 machine. I'm programming in a
> PowerBuilder 8.0 in a windows 2000 machine, I have a
> PSQLODBC-07-02-0002. When I try to access to the Postgres with ODBC,
> PowerBuilder crash with an exeption code, and It doesn't occur with
> SQL SERVER.

>
> The outpus is:
>
> conn=66992464, query='select pbe_name, pbe_edit, pbe_type, pbe_cntr,
> pbe_work, pbe_seqn, pbe_flag from "postgres".pbcatedt order by
> pbe_name, pbe_seqn'

That's not a legal query to 7.2.2 afaict.  It's presumably erroring
due to the "postgres".pbcatedt.  I think you'd want to drop the
"postgres". portion of the query to make it work.

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #757: ODBC Doesn works
Next
From: Sean Chittenden
Date:
Subject: Schemas not available for pl/pgsql %TYPE....