Re: [18] Policy on IMMUTABLE functions and Unicode updates - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: [18] Policy on IMMUTABLE functions and Unicode updates
Date
Msg-id 3faa3e88f6336c8a61aab732f6d2f3f1f26eee7a.camel@j-davis.com
Whole thread Raw
In response to Re: [18] Policy on IMMUTABLE functions and Unicode updates  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [18] Policy on IMMUTABLE functions and Unicode updates
List pgsql-hackers
On Tue, 2024-07-23 at 08:49 -0400, Robert Haas wrote:
> Hmm. I think we might have some unique problems due to the fact that
> we rely partly on the operating system behavior, partly on libicu,
> and
> partly on our own internal tables.

The reliance on the OS is especially problematic for reasons that have
already been discussed extensively.

One of my strongest motivations for PG_C_UTF8 was that there was still
a use case for libc in PG16: the "C.UTF-8" locale, which is not
supported at all in ICU. Daniel Vérité made me aware of the importance
of this locale, which offers code point order collation combined with
Unicode ctype semantics.

With PG17, between ICU and the builtin provider, there's little
remaining reason to use libc (aside from legacy).

Regards,
    Jeff Davis




pgsql-hackers by date:

Previous
From: Paul Jungwirth
Date:
Subject: Re: [PATCH] GROUP BY ALL
Next
From: Heikki Linnakangas
Date:
Subject: Re: Direct SSL connection and ALPN loose ends