Re: Identifier case folding notes - Mailing list pgsql-hackers

From Tino Wildenhain
Subject Re: Identifier case folding notes
Date
Msg-id 487493B2.90506@wildenhain.de
Whole thread Raw
In response to Identifier case folding notes  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Identifier case folding notes  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Hi,

Peter Eisentraut wrote:
...
> 4. Compare the "name" data type in a case-insensitive manner.  This would 
> probably address most problem cases.  Again, you can't have objects with names 
> different in case only.  One condition to implementing this would be that this 
> behavior would have be tied down globally at initdb, because it affects system 
> indexes and shared catalogs.  That might be impractical for some, because 
> you'd need different instances for different behaviors, especially when you 
> want to host multiple applications or want to port an affected application to 
> the native PostgreSQL behavior over time.

The whole stuff as I understand is to fix the behavior with applications 
creating objects without quotes and accessing them "QUOTEDUPPERCASE"?

Would a small script fixing the schema by using rename not fix this for
many applications?

T.

pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: Auto-explain patch
Next
From: "Marko Kreen"
Date:
Subject: review: table function support