Message-Id: <4.1.19990921013859.00c0f500@mailer.isn.net>
Date: Tue, 21 Sep 1999 01:43:07 -0300
To: pgsql-general@hub.org
From: Charles Tassell <ctassell@isn.net>
Subject: Re: [GENERAL] Case sensitivity
In-Reply-To: <37E6691B.9B6C77C7@fphome.com>
References: <199909201632.MAA05831@candle.pha.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Just a suggestion, but if you have or are a C programmer, you could edit
the part of Postgres that receives queries to convert everything it
receives to lower case.  Might slow things down a bit, but it should solve
your problem.  Alternatively, you could do the same thing to the ODBC
driver, which might be a bit easier and have less of a performance impact.

At 02:04 PM 9/20/99, Dana Powers wrote:
>Bruce Momjian wrote:
>> 
>> > > > I am evaluating whether it is possible to migrate our Contact manager
>> > > > system to Postgres on Linux, but I am having difficulty because the
>> > > > client software was most moronically programmed to access tables using
>> > The problem is, if you create a table without "", the table name
>> > defaults to lower case, and all non ""ed references to the table also
>> > default to all lower case but if you create a table with ""s you cannot
>> > access it unless you specify all references to it also in ""s. My
>> > question is, is there anyway to nullify the "" behavior and set all
>> > tables to lowercase?
>> 
>> So you are creating with quotes, but want to access it without quotes?
>> Can't do that.  Why not just remove the quotes from the queries?  I
>> suppose you could hack out the quote stuff to force everything to
>> lowercase, even if it has quotes.
>> 
>Problem is, I don't have control over the client queries. Third party
>closed source contact manager. So I guess I'll try to hack something
>together. Thanks Bruce
>Dana
>
>************
>