Re: The folding of unquoted names to lower case in PostgreSQL - Mailing list pgsql-general

From Tom Lane
Subject Re: The folding of unquoted names to lower case in PostgreSQL
Date
Msg-id 23499.1047674969@sss.pgh.pa.us
Whole thread Raw
In response to Re: The folding of unquoted names to lower case in PostgreSQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
"scott.marlowe" <scott.marlowe@ihs.com> writes:
> On Fri, 14 Mar 2003, Tom Lane wrote:
>> Not really, because it would break everything in sight.  (Hint: all the
>> system catalog names are lower-case ...)

> Right, we've mentioned it before.  I still think it would be possible to
> make one stick, as long as you either had some kind of kludgy wrapper for
> system catalogs, or a way to make them uppercase after booting up.

> I maintain that if postgresql works out of spec, it should, if possible,
> have a way of working within the spec if it can, so we can attract more
> conversion customers from the (currently) more comlpiant databases.

Yeah, I know.  So far I've not seen any proposals for this that I could
support (in particular I don't want to be forced into looking at
upper-cased system catalogs) ... but it's an open problem.  Maybe
someone will have a bright idea sometime about how to make everyone happy.

            regards, tom lane

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Corrupted sequences
Next
From: Tom Lane
Date:
Subject: Re: The folding of unquoted names to lower case in PostgreSQL