Re: pg_collation.collversion for C.UTF-8 - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: pg_collation.collversion for C.UTF-8
Date
Msg-id 3b7cbd2dd58e1343f6151091e7c139b9c6b4dc26.camel@j-davis.com
Whole thread Raw
In response to Re: pg_collation.collversion for C.UTF-8  (Peter Eisentraut <peter@eisentraut.org>)
List pgsql-hackers
On Wed, 2023-06-07 at 23:28 +0200, Peter Eisentraut wrote:
> On 06.06.23 21:23, Jeff Davis wrote:
> > What about ICU? How should provider=icu locale=C.UTF-8 behave? We
> > could:
>
> It should be an error.
>
> > a. Just pass it to the provider and see what happens (older
> > versions of
> > ICU would interpret it as en-US-u-va-posix; newer versions would
> > give
> > the root locale).
>
> This, but with an error instead of a warning.

If we do that, a plain "initdb -D data" will fail if LANG=C.UTF-8.

Perhaps that's fine, but certainly some buildfarm members would
complain. I'm not sure how many users would be affected.

Regards,
    Jeff Davis




pgsql-hackers by date:

Previous
From: Jeremy Schneider
Date:
Subject: Re: Let's make PostgreSQL multi-threaded
Next
From: Andres Freund
Date:
Subject: Re: is pg_log_standby_snapshot() really needed?