Feedback-ID: i76984098:Fastmail
Message-ID: <5b0f58e4-f0cd-4a27-91bd-9a83a65c86d5@aklaver.com>
Date: Sun, 22 Sep 2024 09:53:58 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: glibc updarte 2.31 to 2.38
To: =?UTF-8?Q?Paul_F=C3=B6rster?= <paul.foerster@gmail.com>,
 Joe Conway <mail@joeconway.com>
Cc: "Peter J. Holzer" <hjp-pgsql@hjp.at>, pgsql-general@lists.postgresql.org
References: <B927CE6F-0A36-4237-BD4D-75CD609F3E89@gmail.com>
 <20240919174349.grrz4w25jmxfk77a@hjp.at>
 <58CD40AA-6316-40B6-89C2-390D16FF5FA0@gmail.com>
 <20240920223316.muvdgqekzh6dvcii@hjp.at>
 <DA5B67BD-F5EB-4566-B8C4-AFBBB0753CF4@gmail.com>
 <b281ad68-efb5-40d3-b03b-5d7c1e111914@joeconway.com>
 <2D395465-69B2-46C9-9B6A-84BF73D2379A@gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <2D395465-69B2-46C9-9B6A-84BF73D2379A@gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/5b0f58e4-f0cd-4a27-91bd-9a83a65c86d5%40aklaver.com>
Precedence: bulk

On 9/22/24 09:48, Paul Förster wrote:
> Hi Joe
> 
>> On 22. Sep, 2024, at 15:47, Joe Conway <mail@joeconway.com> wrote:
>>
>> Note that moving to ICU might improve things, but there are similar potential issues with ICU as well. The trick there would be to get your OS distro provider to maintain the same ICU version across major versions of the distro, which is not the case currently. Nor does the PGDG repo do that.
> 
> Then I strongly suggest that the PostgreSQL developers develop a fail safe sorting mechanism that holds for generations of locale changes.

https://www.postgresql.org/docs/17/release-17.html#RELEASE-17-HIGHLIGHTS

Add a builtin platform-independent collation provider (Jeff Davis)

This supports C and C.UTF-8 collations.

> 
> Cheers,
> Paul
> 
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com