Re: Pre-proposal: unicode normalized text - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Pre-proposal: unicode normalized text
Date
Msg-id 4341fa42069c5b9098cb79e394d564f7fe45796a.camel@j-davis.com
Whole thread Raw
In response to Re: Pre-proposal: unicode normalized text  (Peter Eisentraut <peter@eisentraut.org>)
Responses Re: Pre-proposal: unicode normalized text
List pgsql-hackers
On Fri, 2023-10-06 at 09:58 +0200, Peter Eisentraut wrote:
> If you want to be rigid about it, you also need to consider whether
> the
> Unicode version used by the ICU library in use matches the one used
> by
> the in-core tables.

What problem are you concerned about here? I thought about it and I
didn't see an obvious issue.

If the ICU unicode version is ahead of the Postgres unicode version,
and no unassigned code points are used according to the Postgres
version, then there's no problem.

And in the other direction, there might be some code points that are
assigned according to the postgres unicode version but unassigned
according to the ICU version. But that would be tracked by the
collation version as you pointed out earlier, so upgrading ICU would be
like any other ICU upgrade (with the same risks). Right?

Regards,
    Jeff Davis




pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: document the need to analyze partitioned tables
Next
From: Robert Haas
Date:
Subject: Re: Pre-proposal: unicode normalized text