msquery and double quoting column names

From: Giulio Orsero <giulioo(at)pobox(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: msquery and double quoting column names
Date: 2004-08-17 08:39:00
Message-ID: cfsg71$22np$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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(at)pobox(dot)com

Browse pgsql-odbc by date

  From Date Subject
Next Message Antonio Pennino 2004-08-18 13:18:33 Re: problem with CVS version
Previous Message Wolfgang.Fuertbauer 2004-08-16 07:24:57 Re: Problem with VB6, DAO, Data Control: Update does not work