MIME-Version: 1.0
References: <45f0cd77-9c85-4c5e-9396-adbccdb635e2@manitou-mail.org>
 <f8d09d8f3d53daa9cdb446d021fe33d6ff7f1ee3.camel@j-davis.com>
 <ab925f69-5f9d-f85e-b87c-bd2a44798659@joeconway.com> <221408.1686079526@sss.pgh.pa.us>
In-Reply-To: <221408.1686079526@sss.pgh.pa.us>
From: Robert Haas <robertmhaas@gmail.com>
Date: Tue, 6 Jun 2023 15:37:17 -0400
Message-ID: <CA+Tgmob-XgUgGrDx4sEMS3t0AQFgpm4KZgRuCd58bY+TsUO1tQ@mail.gmail.com>
Subject: Re: Order changes in PG16 since ICU introduction
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Joe Conway <mail@joeconway.com>, Jeff Davis <pgsql@j-davis.com>, 
	Daniel Verite <daniel@manitou-mail.org>, 
	Peter Eisentraut <peter.eisentraut@enterprisedb.com>, 
	Andrew Gierth <andrew@tao11.riddles.org.uk>, pgsql-hackers@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BTgmob-XgUgGrDx4sEMS3t0AQFgpm4KZgRuCd58bY%2BTsUO1tQ%40mail.gmail.com>
Precedence: bulk

On Tue, Jun 6, 2023 at 3:25=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Joe Conway <mail@joeconway.com> writes:
> > On 6/6/23 15:18, Jeff Davis wrote:
> >> The locale "C" is a special case, documented as a non-locale. So, if
> >> LOCALE/--locale apply to ICU, then either ICU needs to handle locale
> >> "C" in the expected way (v8 patch series); or when we see locale "C" w=
e
> >> need to somehow change the provider into something that can handle it
> >> (v6 patch series changes it to the "none" provider).
>
> > +1 to the latter approach
>
> Also +1, except that I find "none" a rather confusing choice of name.
> There *is* a provider, it's just PG itself not either libc or ICU.
> I thought Joe's suggestion of "internal" made more sense.

Or perhaps "builtin" or "postgresql".

I'm just thinking that "internal" as a type name kind of means "you
shouldn't be touching this from SQL" and we don't want to give people
the idea that the "C" locale isn't something you should use.

--=20
Robert Haas
EDB: http://www.enterprisedb.com