Re: SQLTables and case sensitivity - Mailing list pgsql-odbc

From Merlin Moncure
Subject Re: SQLTables and case sensitivity
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD343@Herge.rcsinc.local
Whole thread Raw
In response to SQLTables and case sensitivity  ("Chris Ingram" <cingram@intellisync.com>)
List pgsql-odbc
> 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

pgsql-odbc by date:

Previous
From: "Chris Ingram"
Date:
Subject: SQLTables and case sensitivity
Next
From: "Chris Ingram"
Date:
Subject: Re: PATCH: SQLTables and case sensitivity