From: | Steve Haresnape <s(dot)haresnape(at)creativeintegrity(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Fwd: Camel case identifiers and folding |
Date: | 2019-03-16 08:53:33 |
Message-ID: | CAJrKPxd+yxM=oBtECaHpm7zrjCutQ23THV7aHOJ8LbyONJiJqQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
My apologies I sent this reply to David only by mistake.
---------- Forwarded message ---------
From: Steve Haresnape <s(dot)haresnape(at)creativeintegrity(dot)co(dot)nz>
Date: Fri, 15 Mar 2019 at 13:09
Subject: Re: Camel case identifiers and folding
To: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
As I said, I don't want to quote my identifiers. I know what that does. I
want to specify them in a certain way, see them in that same way, but refer
to them in any old way.
You can call it normalize or fold or whatever. It's a bad design choice,
and not even a completely compliant choice.
Is a cure contemplated? I know it's not just me that dislikes this.
On Fri, 15 Mar 2019 at 12:21, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:
> On Thu, Mar 14, 2019 at 4:07 PM Steve Haresnape
> <s(dot)haresnape(at)creativeintegrity(dot)co(dot)nz> wrote:
> >
> > I'm porting a sql server database to postgresql 9.6. My camelCase
> identifiers are having their humps removed. This is disconcerting and sad.
> >
> > Is there a cure for this?
>
> No
>
> >I don't want to quote my identifiers unless I have to.
>
> PostgreSQL made the choice long ago to normalize unquoted identifiers
> to lower case. Quoting them will preserve whatever you type,
> including case.
>
> David J.
>
--
Steve Haresnape
60 Kauri Road, Awhitu, RD 4 Waiuku 2684
s(dot)haresnape(at)creativeintegrity(dot)co(dot)nz
Phone: (09) 235 1698
Mobile: 021 514 666
--
Steve Haresnape
60 Kauri Road, Awhitu, RD 4 Waiuku 2684
s(dot)haresnape(at)creativeintegrity(dot)co(dot)nz
Phone: (09) 235 1698
Mobile: 021 514 666
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-03-16 14:25:16 | Re: Fwd: Camel case identifiers and folding |
Previous Message | Tom Lane | 2019-03-16 01:43:06 | Re: Conditional INSERT |