Re: Bug #757: ODBC Doesn works

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <lazaro(at)matmor(dot)unam(dot)mx>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Bug #757: ODBC Doesn works
Date: 2002-09-04 21:42:05
Message-ID: 20020904143928.E60532-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


On Wed, 4 Sep 2002 pgsql-bugs(at)postgresql(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sean Chittenden 2002-09-04 21:53:18 Schemas not available for pl/pgsql %TYPE....
Previous Message pgsql-bugs 2002-09-04 20:51:34 Bug #757: ODBC Doesn works