Fwd: Camel case identifiers and folding

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

In response to

Responses

Browse pgsql-general by date

  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