From: Charles Tassell <ctassell@isn.net>
To: pgsql-general@hub.org
Subject: Re: [GENERAL] Case sensitivity
Date: Tue, 21 Sep 1999 01:43:07 -0300
Message-ID: <4.1.19990921013859.00c0f500@mailer.isn.net> (raw)
In-Reply-To: <37E6691B.9B6C77C7@fphome.com>
References: <199909201632.MAA05831@candle.pha.pa.us>
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
>
>************
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: ctassell@isn.net, pgsql-general@hub.org
Subject: Re: [GENERAL] Case sensitivity
In-Reply-To: <4.1.19990921013859.00c0f500@mailer.isn.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox