Re: Identifier case folding notes

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Identifier case folding notes
Date: 2008-07-09 10:32:18
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


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?


In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Kreen 2008-07-09 11:05:03 review: table function support
Previous Message ITAGAKI Takahiro 2008-07-09 09:48:57 Re: Auto-explain patch