Re: pgsql: Add option to use ICU as global locale provider - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: pgsql: Add option to use ICU as global locale provider
Date
Msg-id 2298daf1-c9c7-be30-7319-519a768b9405@enterprisedb.com
Whole thread Raw
In response to Re: pgsql: Add option to use ICU as global locale provider  (Christoph Berg <myon@debian.org>)
Responses Re: pgsql: Add option to use ICU as global locale provider  (Christoph Berg <myon@debian.org>)
List pgsql-hackers
On 19.03.22 18:53, Christoph Berg wrote:
> Re: Peter Eisentraut
>> Since some (legacy) code still uses the libc locale facilities
>> directly, we still need to set the libc global locale settings even if
>> ICU is otherwise selected.  So pg_database now has three
>> locale-related fields: the existing datcollate and datctype, which are
>> always set, and a new daticulocale, which is only set if ICU is
>> selected.  A similar change is made in pg_collation for consistency,
>> but in that case, only the libc-related fields or the ICU-related
>> field is set, never both.
> 
> Since the intended usage seems to be that databases should either be
> using libc, or the ICU locales, but probably not both at the same
> time, does it make sense to clutter the already very wide `psql -l`
> output with two new extra columns?

Good point, let me think about that.



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pgsql: Add option to use ICU as global locale provider
Next
From: Tomas Vondra
Date:
Subject: Re: Column Filtering in Logical Replication