Thread: Bug #757: ODBC Doesn works

Lazaro (lazaro@matmor.unam.mx) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
ODBC Doesn works

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
havea PSQLODBC-07-02-0002. When I try to access to the Postgres with ODBC, PowerBuilder crash with an exeption code,
andIt 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".pbcatedtorder by pbe_name, pbe_seqn' 
ERROR from backend during send_query: 'ERROR:  parser: parse error at or near "."'
STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query'
                 ------------------------------------------------------------
                 hdbc=66992464, stmt=66986264, result=67013344
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=0, statement='select pbe_name, pbe_edit, pbe_type, pbe_cntr, pbe_work, pbe_seqn,
pbe_flagfrom "postgres".pbcatedt order by pbe_name, pbe_seqn' 

The user name with I conect with the database is postgres, but It occur in the same way with any user

If I access with pgadmin-1.0.2 in the same machine, I have no problem

Sample Code


No file was uploaded with this report

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.