On Fri, 8 Oct 2004 21:45:26 +0100, "Dave Page" <dpage@vale-housing.co.uk>
wrote:
>I've just uploaded a new snapshot to
>ftp://ftp.postgresql.org/pub/odbc/versions/snapshots/ (it should hit the
>mirrors within 24 hours). This version of the driver is a minor update
>with a fix to the string sizing code in SQLGetInfo, and removal of the
>need for tables to be in the search path or public schema for them to be
>returned by SQLTables.
Since you are in a development phase, can you tell me if the following
feature is in your roadmap?
Add a check box "Quote every table/field identifier" yes/no, default: no
This would solve one of the greatest problems interacting with psql server:
- On the server you define MyTable.MyField
- Excel/MSQuery receives MyTable.MyField names through ODBC
- Excel/MSQuery builds a query with MyTable.MyField (not
"MyTable"."MyField")
- psql server lowercase to mytable.myfield and errors out
I read all the explanations about how this behavior is right/good, but users
just want it to work.
Thanks
--
giulioo@pobox.com