Re: pgsql: Add standard collation UNICODE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Peter Eisentraut <peter(at)eisentraut(dot)org>, pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Add standard collation UNICODE
Date: 2023-03-11 20:47:41
Message-ID: 1253026.1678567661@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> 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.

snapper is showing this failure too [1], which makes me wonder if it's
a locally-customizable option.

In general, I see no good reason for our regression tests to be making
assumptions about exactly how ICU's root locale behaves, so I'd suggest
just lobotomizing this test case so it doesn't depend on upper/lower
sort order.

regards, tom lane

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=snapper&dt=2023-03-11%2016%3A50%3A13

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2023-03-11 21:25:27 pgsql: meson: fix header path of ossp-uuid
Previous Message Jeff Davis 2023-03-11 18:20:33 Re: pgsql: Add standard collation UNICODE