From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>,  Sandro Santilli
 <strk@kbt.io>,  Tom Lane <tgl@sss.pgh.pa.us>,  Regina Obe <lr@pcorp.us>,
  pgsql-hackers@lists.postgresql.org
Subject: Re: Order changes in PG16 since ICU introduction
In-Reply-To: <c69094c540a60ebe1946ed21eb6aa38320187804.camel@j-davis.com>
	(Jeff Davis's message of "Fri, 21 Apr 2023 14:25:26 -0700")
Message-ID: <87v8hoexdv.fsf@news-spur.riddles.org.uk>
References: <000b01d97465$c34bbd60$49e33820$@pcorp.us>
	<3353947.1682092131@sss.pgh.pa.us> <ZELDOktA75yYG4Z2@hst.kbt.io>
	<533d93c5-f604-8e5f-4a48-975c08c53d59@enterprisedb.com>
	<878relf7cb.fsf@news-spur.riddles.org.uk>
	<7d62b28d808617aae43a68bdfba14d7075f048ea.camel@j-davis.com>
	<87zg71djuz.fsf@news-spur.riddles.org.uk>
	<c69094c540a60ebe1946ed21eb6aa38320187804.camel@j-davis.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (berkeley-unix)
Date: Fri, 21 Apr 2023 22:35:09 +0100
MIME-Version: 1.0
Content-Type: text/plain
Archived-At: 
 <https://www.postgresql.org/message-id/87v8hoexdv.fsf%40news-spur.riddles.org.uk>
Precedence: bulk

>>>>> "Jeff" == Jeff Davis <pgsql@j-davis.com> writes:

 >> Is that the right fix, though? (It forces --locale-provider=libc for
 >> the cluster default, which might not be desirable?)

 Jeff> For the "no locale" behavior (memcmp()-based) the provider needs
 Jeff> to be libc. Do you see an alternative?

Can lc_collate_is_c() be taught to check whether an ICU locale is using
POSIX collation?

There's now another bug in that --no-locale no longer does the same
thing as --locale=C (which is its long-established documented behavior).
How should these various options interact? This all seems not well
thought out from a usability perspective, and I think a proper fix
should involve a bit more serious consideration.

-- 
Andrew.