Re: Identifier case folding notes

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Tino Wildenhain" <tino(at)wildenhain(dot)de>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Identifier case folding notes
Date: 2008-07-09 11:42:15
Message-ID: 873amjthbc.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Tino Wildenhain" <tino(at)wildenhain(dot)de> writes:

> 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?

Well there are other circumstances where this can arise

select "FOO" from (select col as foo from bar)

Not to mention temporary objects which are created and dropped inside
functions.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2008-07-09 12:01:07 Re: Auto-explain patch
Previous Message Simon Riggs 2008-07-09 11:22:56 Re: Auto-explain patch