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

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, <gearond(at)cvc(dot)net>, 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 21:08:54
Message-ID: Pine.LNX.4.33.0303141404290.24099-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 14 Mar 2003, Tom Lane wrote:

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Do you have as much trouble reading those all-uppercase queries as I do?
>
> Yeah, I hate 'em. It's well established that lowercase text is more
> readable than uppercase. I think it's okay style to upcase a few
> critical keywords like SELECT, FROM, WHERE, but beyond that give me
> lowercase ...
>
> But quite aside from questions of taste, we'd need an answer to the
> backwards-compatibility problems before we could think about this.
> Switching to the spec's notions about case would make autocommit look
> like a nonissue :-(

I'm strictly talking about a setting that would only be used on systems
being used to port from databases that fold to uppercase like Oracle. I
wouldn't want any changes that affected folks who didn't turn on the
option, only those who did.

For what I need, a hack that basically folded to upper everything that
didn't start with pg_ would work fine. Now that catalogs live in the
pg_catalog schema, I could just treat anything in the pg_catalog to be
fold to lower, while everything else would fold to upper.

Would that be an acceptable kludge, or would we want the catalog to be
folded to upper in those cases too? I can't see a reason for doing it
that way, since I doubt anyone porting Oracle sql code is gonna be messing
with the catalogs as well.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-03-14 21:12:34 Re: Corrupted sequences
Previous Message Francisco Reyes 2003-03-14 21:02:36 Re: Corrupted sequences