Re: PATCH: SQLTables and case sensitivity

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Chris Ingram" <cingram(at)intellisync(dot)com>, "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: PATCH: SQLTables and case sensitivity
Date: 2005-09-15 07:46:02
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC2C23@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Thanks, patch applied.

Regards, Dave

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Chris Ingram
> Sent: 14 September 2005 21:33
> To: Merlin Moncure
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] 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(at)intellisync(dot)com
> www.intellisync.com
>
> -----Original Message-----
> From: Merlin Moncure [mailto:merlin(dot)moncure(at)rcsonline(dot)com]
> Sent: Wednesday, September 14, 2005 3:39 PM
> To: Chris Ingram
> Cc: pgsql-odbc(at)postgresql(dot)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
>

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2005-09-15 08:12:01 Re: row count with libpq driver
Previous Message Scot Loach 2005-09-15 03:02:15 Re: row count with libpq driver