Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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
> 

pgsql-odbc by date

Next:From: Dave PageDate: 2005-09-15 08:12:01
Subject: Re: row count with libpq driver
Previous:From: Scot LoachDate: 2005-09-15 03:02:15
Subject: Re: row count with libpq driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group