Re: [HACKERS] Can ICU be used for a database's default sort order? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Can ICU be used for a database's default sort order?
Date
Msg-id 75e871c2-bc71-8cf7-7884-bca0eb32ec0c@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] Can ICU be used for a database's default sort order?  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-hackers
On 12/12/2018 15:57, Daniel Verite wrote:
> I think one related issue that the patch works around by using a libc locale
> as a proxy is knowing what to put into libc's LC_CTYPE and LC_COLLATE.
> In fact I've been wondering if that's the main reason for the interface
> implemented by the patch.

So it seems, but then it should be called out more clearly.

> Otherwise, how should these env variables be initialized for ICU
> databases?

I think when using ICU by default, then it should not matter because we
shouldn't be calling any libc functions that use those settings.  Maybe
there need to be some exceptions, but again we should call those out
more clearly.

We could set them to "C" for consistency perhaps.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Reorganize collation lookup time and place
Next
From: Andres Freund
Date:
Subject: Re: Reorganize collation lookup time and place