Feedback-ID: i131946ab:Fastmail
Message-ID: <35c50e81-d9b4-65f9-202a-2879dc4bf455@enterprisedb.com>
Date: Mon, 24 Apr 2023 17:26:42 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.10.0
Subject: Re: Order changes in PG16 since ICU introduction
Content-Language: en-US
To: Jeff Davis <pgsql@j-davis.com>, Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Regina Obe <lr@pcorp.us>,
 Sandro Santilli <strk@kbt.io>, pgsql-hackers@lists.postgresql.org
References: <000b01d97465$c34bbd60$49e33820$@pcorp.us>
 <3353947.1682092131@sss.pgh.pa.us> <ZELDOktA75yYG4Z2@hst.kbt.io>
 <533d93c5-f604-8e5f-4a48-975c08c53d59@enterprisedb.com>
 <3365333.1682098091@sss.pgh.pa.us> <002d01d97477$f0395640$d0ac02c0$@pcorp.us>
 <3367226.1682099185@sss.pgh.pa.us> <003b01d9747a$910471c0$b30d5540$@pcorp.us>
 <3368986.1682099982@sss.pgh.pa.us> <000001d9747d$066b7560$13426020$@pcorp.us>
 <3372735.1682101425@sss.pgh.pa.us>
 <f83f089ee1e9acd5dbbbf3353294d24e1f196e95.camel@j-davis.com>
 <CA+TgmobxgvonJT8vO_v0k9_rgDmn0CKvTe48Z=w95rrBqC95KA@mail.gmail.com>
 <f6a433dce54a17aeee64db25f0893e55c8a71e91.camel@j-davis.com>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
In-Reply-To: <f6a433dce54a17aeee64db25f0893e55c8a71e91.camel@j-davis.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/35c50e81-d9b4-65f9-202a-2879dc4bf455%40enterprisedb.com>
Precedence: bulk

On 22.04.23 01:00, Jeff Davis wrote:
> On Fri, 2023-04-21 at 16:33 -0400, Robert Haas wrote:
>> And the fact that "C" or "POSIX" gets transformed into
>> "en-US-u-va-posix"
> 
> I already expressed, on reflection, that we should probably just not do
> that. So I think we're in agreement on this point; patch attached.

This makes sense to me.  This way, if someone specifies 'C' locale 
together with ICU provider they get an error.  They can then choose to 
use the libc provider, to get the performance path, or stick with ICU by 
using the native spelling of the locale.