Message-ID: <20f4e529e17af61bce11fe05cb056f28a809b840.camel@j-davis.com>
Subject: Re: Order changes in PG16 since ICU introduction
From: Jeff Davis <pgsql@j-davis.com>
To: Joe Conway <mail@joeconway.com>, Peter Eisentraut
 <peter@eisentraut.org>,  Daniel Verite <daniel@manitou-mail.org>
Cc: Andrew Gierth <andrew@tao11.riddles.org.uk>, Tom Lane
 <tgl@sss.pgh.pa.us>,  pgsql-hackers@lists.postgresql.org
Date: Thu, 08 Jun 2023 14:15:39 -0700
In-Reply-To: <5ecb1eec-c115-6de9-8dd4-4bf214b8ebda@joeconway.com>
References: <543e4ce6-8205-4aea-b54b-12b9ef747bf6@manitou-mail.org>
	 <654a49f7ff7461bcf47be4181430678d45f93858.camel@j-davis.com>
	 <37520ec1ae9591f83132f82dbd625f3fc2d69c16.camel@j-davis.com>
	 <daa9f060aa2349ebc84444515efece49e7b32c5d.camel@j-davis.com>
	 <c840107b-4cb9-c8e9-abb7-1d8c5e0d51df@enterprisedb.com>
	 <a4388fa3acabf7794ac39fdb471ad97eebdfbe11.camel@j-davis.com>
	 <5111ffef640ec7ed5b75d9791dd18d821e96c31e.camel@j-davis.com>
	 <0f03fa26-741c-b1ee-12ab-566116451ab1@eisentraut.org>
	 <d4fcacbf4ccd829b5d138590bfe8f6d5e72cced8.camel@j-davis.com>
	 <5ecb1eec-c115-6de9-8dd4-4bf214b8ebda@joeconway.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.44.4-0ubuntu1 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/20f4e529e17af61bce11fe05cb056f28a809b840.camel%40j-davis.com>
Precedence: bulk

On Wed, 2023-06-07 at 20:52 -0400, Joe Conway wrote:
> If the provider has no such thing, throw an error.

Just to be clear, that implies that users (and buildfarm members) with
LANG=3DC.UTF-8 in their environment would not be able to run a plain
"initdb -D data"; they'd get an error. It's hard for me to estimate how
many users might be inconvenienced by that, but it sounds like a risk.

Perhaps for this specific case, and only in initdb, we change
C.anything and POSIX.anything to the builtin provider? CREATE DATABASE
and CREATE COLLATION could still reject such locales.

Regards,
	Jeff Davis