Re: Update Unicode data to Unicode 16.0.0

Peter Eisentraut <peter@eisentraut.org>

From: Peter Eisentraut <peter@eisentraut.org>
To: Jeff Davis <pgsql@j-davis.com>, Laurenz Albe <laurenz.albe@cybertec.at>, Joe Conway <mail@joeconway.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-01-22T18:08:10Z
Lists: pgsql-hackers
On 20.01.25 22:39, Jeff Davis wrote:
> On Fri, 2024-11-15 at 17:09 +0100, Peter Eisentraut wrote:
>> The practice of regularly updating the Unicode files is older than
>> the
>> builtin collation provider.  It is similar to updating the time zone
>> files, the encoding conversion files, the snowball files, etc.  We
>> need
>> to move all of these things forward to keep up with the aspects of
>> the
>> real world that this data reflects.
> 
> Should we consider bundling multiple versions of the generated tables
> (header files) along with Postgres?

I wouldn't have a problem with that.

> That would enable a compile-time option to build with an older version
> of Unicode if you want, solving the packager concern that Noah raised.
> It would also make it easier for people to coordinate the Postgres
> version of Unicode and the ICU version of Unicode.

But I don't think it would be a compile-time decision.  I think it would 
be a run-time selection, similar to the theorized multiple-ICU-versions 
feature.  (Those two features might even go together, since a given ICU 
version also sort of assumes a given Unicode version.)




Commits

  1. pg_upgrade: Fix memory leak in check_for_unicode_update().

  2. pg_upgrade check for Unicode-dependent relations.

  3. Update Unicode data to Unicode 16.0.0