Re: SQLTables and case sensitivity

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Chris Ingram" <cingram(at)intellisync(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: SQLTables and case sensitivity
Date: 2005-09-14 19:38:46
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD343@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Chris Ingram 2005-09-14 20:33:03 Re: PATCH: SQLTables and case sensitivity
Previous Message Chris Ingram 2005-09-14 19:10:29 SQLTables and case sensitivity