Re: The folding of unquoted names to lower case in PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-general(at)postgresql(dot)org
Subject: Re: The folding of unquoted names to lower case in PostgreSQL
Date: 2003-03-14 20:49:29
Message-ID: 23499.1047674969@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-03-14 20:57:02 Re: The folding of unquoted names to lower case in PostgreSQL
Previous Message Bruce Momjian 2003-03-14 20:46:06 Re: The folding of unquoted names to lower case in PostgreSQL