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 1pazKX-0001iN-QQ for pgsql-committers@arkaria.postgresql.org; Sat, 11 Mar 2023 13:32:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pazJX-0001Lg-9q for pgsql-committers@arkaria.postgresql.org; Sat, 11 Mar 2023 13:31:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pazJX-0001LX-2g for pgsql-committers@lists.postgresql.org; Sat, 11 Mar 2023 13:31:11 +0000 Received: from relay7-d.mail.gandi.net ([217.70.183.200]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pazJS-00055z-Oq for pgsql-committers@lists.postgresql.org; Sat, 11 Mar 2023 13:31:10 +0000 Received: (Authenticated sender: adsend@dunslane.net) by mail.gandi.net (Postfix) with ESMTPSA id 6B47620004; Sat, 11 Mar 2023 13:31:01 +0000 (UTC) Content-Type: multipart/alternative; boundary="------------tdL9qYKmvoHs40bhVtDyq0ch" Message-ID: Date: Sat, 11 Mar 2023 08:31:00 -0500 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: Jeff Davis , Peter Eisentraut , pgsql-committers@lists.postgresql.org References: <582e43d0a814e09c62ea662dd851f43bfc137a16.camel@j-davis.com> From: Andrew Dunstan In-Reply-To: <582e43d0a814e09c62ea662dd851f43bfc137a16.camel@j-davis.com> 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. --------------tdL9qYKmvoHs40bhVtDyq0ch Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 2023-03-10 Fr 14:44, Jeff Davis wrote: > On Fri, 2023-03-10 at 12:42 +0000, Peter Eisentraut wrote: >>> Add standard collation UNICODE > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=prion&dt=2023-03-10%2018%3A58%3A04 > > Looks like there's still a failure, even after subsequent fix > 3e623ebc7a. I'm wondering how that diff happens, because I tested all > versions of ICU between 50 and 72 (except 58 and 59, where I had build > problems) and 'abc' is always less than 'ABC' in the root locale. > > Must be something simple I'm missing. 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 I'll see about updating the machine (probably by recreating it with a modern AMI) cheers andrew -- Andrew Dunstan EDB:https://www.enterprisedb.com --------------tdL9qYKmvoHs40bhVtDyq0ch Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit


On 2023-03-10 Fr 14:44, Jeff Davis wrote:
On Fri, 2023-03-10 at 12:42 +0000, Peter Eisentraut wrote:

Add standard collation UNICODE

https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=prion&dt=2023-03-10%2018%3A58%3A04

Looks like there's still a failure, even after subsequent fix
3e623ebc7a. I'm wondering how that diff happens, because I tested all
versions of ICU between 50 and 72 (except 58 and 59, where I had build
problems) and 'abc' is always less than 'ABC' in the root locale.

Must be something simple I'm missing.



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


I'll see about updating the machine (probably by recreating it with a modern AMI)


cheers


andrew 

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