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.
smime.p7s
Description: S/MIME Cryptographic Signature
