I don't know if it is the same problem, but I do know that Oracle's ODBC driver
did have a bug in which it used double quotes internally inconsistently. This
made it impossible to query a PostgreSQL table from an Oracle database.
The last I heard is that there has been a patch released, but I have not yet
applied it. The Oracle TAR for the bug is 13953728.6
-- dave
-----Original Message-----
From: Netto [mailto:rcnetto@yahoo.com]
Sent: Friday, October 31, 2003 11:42 AM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] does ODBC quotes table or field's name?
I'm trying to migrate an application made with Delphi from Oracle to
PostgreSQL... There's a problem I think it's related to the ODBC driver... (Not
a problem at all, but a feature). When I execute a sql statement through Delphi,
I receive an error message saying the table does not exists... I intercepted the
SQL statement and notice that ODBC insert quotes around tables and fields name,
no matter how I wrote the sentence into Delphi... Is it really ODBC Driver who
does that? If so, is there a workaround?
Thank you all!
Netto
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html