I've attached a patch for this bug which I've tested using Microsoft
ODBC Test to verify that it fixes the problem I reported. Please let me
know if I should send this to any other email list (such as pgsql-bugs
or pgsql-patches) instead of this one. Thanks.
--
Chris Ingram
Software Developer, Intellisync Corporation
cingram@intellisync.com
www.intellisync.com
-----Original Message-----
From: Merlin Moncure [mailto:merlin.moncure@rcsonline.com]
Sent: Wednesday, September 14, 2005 3:39 PM
To: Chris Ingram
Cc: pgsql-odbc@postgresql.org
Subject: RE: [ODBC] SQLTables and case sensitivity
> I'm running PostgreSQL 8.0 with version 08.01.0003 of the
psqlodbclibpq
> ODBC driver on Microsoft Windows Server 2003. I've noticed that
> PostgreSQL stores unquoted identifiers as all lower case internally.
> With the ODBC catalog functions such as SQLTables, if I don't specify
> the table name with all lower case, it will not find it. For example,
> if I create a table:
[...]
> What is the chance that a fix for this case insensitive problem will
be
> made to the official PostgreSQL ODBC driver?
IMO, 100% if you test it and it fixes the behavior you have noticed, and
submit a patch. I remember looking at this a while back and the
existing code looked bugged.
Merlin