From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] Case sensitivity |
Date: | 1999-09-21 04:43:07 |
Message-ID: | 4.1.19990921013859.00c0f500@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>************
>
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 1999-09-21 04:47:34 | Re: [GENERAL] getting the value from nextval('sequencename') |
Previous Message | Nam Do | 1999-09-20 22:14:34 |