Re: PATCH: SQLTables and case sensitivity

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