Re: Identifier case folding notes

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.