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 <pgsql-committers-owner+archive@lists.postgresql.org>)
	id 1painE-00024a-M7
	for pgsql-committers@arkaria.postgresql.org; Fri, 10 Mar 2023 19:52:44 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-committers-owner+archive@lists.postgresql.org>)
	id 1painC-0001r1-JR
	for pgsql-committers@arkaria.postgresql.org; Fri, 10 Mar 2023 19:52:42 +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 <jkatz@postgresql.org>)
	id 1painC-0001qs-Ca
	for pgsql-committers@lists.postgresql.org; Fri, 10 Mar 2023 19:52:42 +0000
Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <jkatz@postgresql.org>)
	id 1pain9-0003Dy-N5
	for pgsql-committers@lists.postgresql.org; Fri, 10 Mar 2023 19:52:42 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=postgresql.org; s=20171124; h=To:In-Reply-To:Cc:References:Message-Id:Date:
	Subject:Mime-Version:From:Content-Transfer-Encoding:Content-Type:Sender:
	Reply-To:Content-ID:Content-Description;
	bh=6NRCpQZFFQqGpVqHVMymYPg3CRkHHaWuE7LcrxXv7Dw=; b=xj/3Txn326QhzuZ4rhTap8WgEJ
	izn0POI0mKS0T9DFGlcoCCjUp2TgPGl42sUxsVYekr2uERlC7EU8cFvuI+P4n9E1Q5Pg3yW67c497
	+sRLW+pmjOLTrHzx7J1uQVo4Cu/NC0et+J71evzfuKQdia2lbYz8pb02J2OVyUQNKAijYuX6nPEFb
	Cc1MfJczLWr1QhViVtqw2XPKAUwxKVQqh0QecNARwGVgUYy1BeiszgwkoELdB+ISRnKqmO5FKBz63
	1iea75gZi3rxYkBoLAc/JU6XS9chASVIOBKr3WknEnZrhZfO9LeWe3LwXBt/8dv8Ir0NYg7urE8jb
	JA81Oshg==;
Received: from [2600:381:e00e:9fd6:3d52:a4b4:bb25:ede] (helo=smtpclient.apple)
	by meldrar.postgresql.org with esmtpsa
 (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <jkatz@postgresql.org>)
	id 1pain7-00052v-8A; Fri, 10 Mar 2023 19:52:39 +0000
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: "Jonathan S. Katz" <jkatz@postgresql.org>
Mime-Version: 1.0 (1.0)
Subject: Re: pgsql: Add standard collation UNICODE
Date: Fri, 10 Mar 2023 11:52:22 -0800
Message-Id: <6648546F-52B6-4525-A13B-414D99655033@postgresql.org>
References: <582e43d0a814e09c62ea662dd851f43bfc137a16.camel@j-davis.com>
Cc: Peter Eisentraut <peter@eisentraut.org>,
 pgsql-committers@lists.postgresql.org
In-Reply-To: <582e43d0a814e09c62ea662dd851f43bfc137a16.camel@j-davis.com>
To: Jeff Davis <pgsql@j-davis.com>
X-Mailer: iPhone Mail (20D67)
X-Host-Lookup-Failed: Reverse DNS lookup failed for
 2600:381:e00e:9fd6:3d52:a4b4:bb25:ede (failed)
List-Id: <pgsql-committers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-committers@lists.postgresql.org>
List-Owner: <mailto:pgsql-committers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-committers>
Archived-At: 
 <https://www.postgresql.org/message-id/6648546F-52B6-4525-A13B-414D99655033%40postgresql.org>
Precedence: bulk


> On Mar 10, 2023, at 11:44 AM, Jeff Davis <pgsql@j-davis.com> wrote:
>=20
> =EF=BB=BFOn Fri, 2023-03-10 at 12:42 +0000, Peter Eisentraut wrote:
>>> Add standard collation UNICODE
>=20
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dprion&dt=3D2023-=
03-10%2018%3A58%3A04
>=20
> 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.

Do you have any customizations or other tests in
place for adjusting the collation ordering that
could be affecting the local build? The capitals
should be first. I can try my own local test in a bit.

Jonathan=