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

From pgsql-bugs@postgresql.org
Subject Bug #757: ODBC Doesn works
Date
Msg-id 20020904205134.C1040476669@postgresql.org
Whole thread Raw
Responses Re: Bug #757: ODBC Doesn works  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Bug #756: suggestion: file with password instead of $PGPASSWORD
Next
From: Stephan Szabo
Date:
Subject: Re: Bug #757: ODBC Doesn works