Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pbNSV-00018A-PI for pgsql-committers@arkaria.postgresql.org; Sun, 12 Mar 2023 15:18:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pbNSU-0001LF-Kb for pgsql-committers@arkaria.postgresql.org; Sun, 12 Mar 2023 15:18:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pbNSU-0001L5-DH for pgsql-committers@lists.postgresql.org; Sun, 12 Mar 2023 15:18:02 +0000 Received: from relay1-d.mail.gandi.net ([2001:4b98:dc4:8::221]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pbNSN-0001ZJ-14 for pgsql-committers@lists.postgresql.org; Sun, 12 Mar 2023 15:18:01 +0000 Received: (Authenticated sender: adsend@dunslane.net) by mail.gandi.net (Postfix) with ESMTPSA id BF672240003; Sun, 12 Mar 2023 15:17:48 +0000 (UTC) Content-Type: multipart/alternative; boundary="------------G0Uara0EvVm2q7B7wS9rQXL6" Message-ID: <12021ac6-8a4b-99b7-f584-1b589d32fc9e@dunslane.net> Date: Sun, 12 Mar 2023 11:17:47 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Subject: Re: pgsql: Add standard collation UNICODE Content-Language: en-US To: Andres Freund , Jeff Davis Cc: Peter Eisentraut , pgsql-committers@lists.postgresql.org References: <582e43d0a814e09c62ea662dd851f43bfc137a16.camel@j-davis.com> <231acf388c37597a9f0f8a3af9a899df99c28e1d.camel@j-davis.com> <20230311220515.x45vln6ogzyd57p7@awork3.anarazel.de> From: Andrew Dunstan In-Reply-To: <20230311220515.x45vln6ogzyd57p7@awork3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------G0Uara0EvVm2q7B7wS9rQXL6 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 2023-03-11 Sa 17:05, Andres Freund wrote: > Hi, > > On 2023-03-11 10:20:33 -0800, Jeff Davis wrote: >> On Sat, 2023-03-11 at 08:31 -0500, Andrew Dunstan wrote: >>> It's fairly old: >>> >>> $ rpm -q -a | grep icu >>> libicu-50.2-4.0.amzn1.x86_64 >>> libicu-devel-50.2-4.0.amzn1.x86_64 >> FWIW I tried ICU 50.2 (built from sources) and the root locale still >> sorts lowercase first. > On one my hacking-on-meson-build trees ([1]) I saw the problem in CI, on > centos-7. Yeah, I have a Centos 7 VM sitting here which I fired up and reproduced it just now. I have the source package downloaded from the Centos archives, but given that it's also happening on Debian 7, perhaps it's not something packaging-specific. cheers andrew -- Andrew Dunstan EDB:https://www.enterprisedb.com --------------G0Uara0EvVm2q7B7wS9rQXL6 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

On 2023-03-11 Sa 17:05, Andres Freund wrote:

Hi,

On 2023-03-11 10:20:33 -0800, Jeff Davis wrote:

On Sat, 2023-03-11 at 08:31 -0500, Andrew Dunstan wrote:

It's fairly old:

$ rpm -q -a | grep icu
 libicu-50.2-4.0.amzn1.x86_64
 libicu-devel-50.2-4.0.amzn1.x86_64

FWIW I tried ICU 50.2 (built from sources) and the root locale still
sorts lowercase first.

On one my hacking-on-meson-build trees ([1]) I saw the problem in CI, on
centos-7.

Yeah,

I have a Centos 7 VM sitting here which I fired up and reproduced it just now. I have the source package downloaded from the Centos archives, but given that it's also happening on Debian 7, perhaps it's not something packaging-specific.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

--------------G0Uara0EvVm2q7B7wS9rQXL6--