From: Dev Kumkar <devdas.kumkar@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Thomas Kellerer <spam_eater@gmx.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Unquoted column names fold to lower case
Date: Thu, 4 Jul 2013 00:19:20 +0530
Message-ID: <CALSLE1POR2hJa4HMSNshDoruWsEZ+3miLffnyZLqZ6GmcLTG7Q@mail.gmail.com> (raw)
In-Reply-To: <10699.1372868406@sss.pgh.pa.us>
References: <CALSLE1PeLH4iqEyT5RH=d4Y3VmrRyxm6rvnV9fNC0++u9h-WWw@mail.gmail.com>
<1372858894.60580.YahooMailClassic@web161605.mail.bf1.yahoo.com>
<kr1bl9$96d$1@ger.gmane.org>
<20130703152402.GA6492@momjian.us>
<CALSLE1N-WnxujTjD+ED9u4pjFrUnHbm8zr9+SmMvu5NPAMGw1g@mail.gmail.com>
<20130703153524.GB6492@momjian.us>
<CALSLE1Pxn7aL1P4tW5vL6GL7h9V1YrZU2KmFeTaHQ2ok4hb_xg@mail.gmail.com>
<10699.1372868406@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
On Wed, Jul 3, 2013 at 9:50 PM, Tom Lane <tgl@sss.pgh.pa.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...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: devdas.kumkar@gmail.com, tgl@sss.pgh.pa.us, bruce@momjian.us, spam_eater@gmx.net
Subject: Re: Unquoted column names fold to lower case
In-Reply-To: <CALSLE1POR2hJa4HMSNshDoruWsEZ+3miLffnyZLqZ6GmcLTG7Q@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox