7.4.3, latest win odbc drivers.
I see there are many users having problems with mixed case column names
create table t1 ("Field" varchar(8));
and accessing them through msquery (default tool in office suite) due to
msquery not enclosing column names in quotes so that msquery does
select Field from t1;
and postgres rewrites it into
select field from t1
thus not finding the column.
I know the solution is to do sql by hand in msquery, but this is not
optimal; so this post is to ask if someone has done one of the
following:
- modified the pgsql win odbc driver to add an option like "quote every
column name before sending it to the server"
- created a patch to postgres server to look for the column name as
typed by the user before lowercasing it.
Thanks.
--
giulioo@pobox.com