Bug #757: ODBC Doesn works

Lazaro (lazaro(at)matmor(dot)unam(dot)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 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'
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_flag from "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