Re: Unquoted column names fold to lower case

From: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Unquoted column names fold to lower case
Date: 2013-07-03 18:49:20
Message-ID: CALSLE1POR2hJa4HMSNshDoruWsEZ+3miLffnyZLqZ6GmcLTG7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Jul 3, 2013 at 9:50 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> > Any plans to fix this in next release or having a patch to fix this?
>
> No.
>
> This has been discussed (many times) before. There isn't any feasible
> way to change this behavior without breaking an incredible amount of
> code, much of which isn't even under our control. The marginal increase
> in standards compliance is not worth the pain --- especially when the
> aspect of the standard in question isn't even one that most of us like.
> (All-upper-case is hard to read.)
>
> If this is a deal-breaker for you, then I'm sorry, but you need to find
> another database. Postgres settled on this behavior fifteen years ago,
> and we're not changing it now.
>

Again my question was not to change the default behavior and make then
All-upper-case as there is no need to change it.

Rather it was for alias names and if those are with upper case or mix case
then wouldn't it will be good to preserve same. For me these changes to
have aliases quoted are manageable and I was just checking for any thoughts
here.

Regards...

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Alvaro Herrera 2013-07-03 19:08:31 Re: Unquoted column names fold to lower case
Previous Message Dev Kumkar 2013-07-03 18:46:14 Re: Unquoted column names fold to lower case