Re: Allow tailoring of ICU locales with custom rules

On 02.03.23 16:39, Laurenz Albe wrote:
> On Wed, 2023-02-22 at 18:35 +0100, Peter Eisentraut wrote:
>>> - there doesn't seem to be a way to add rules to template1.
>>> If someone wants to have icu rules and initial contents to their new
>>> databases, I think they need to create a custom template database
>>> (from template0) for that purpose, in addition to template1.
>>>   From a usability standpoint, this is a bit cumbersome, as it's
>>> normally the role of template1.
>>> To improve on that, shouldn't initdb be able to create template0 with
>>> rules too?
>>
>> Right, that would be an initdb option.  Is that too many initdb options
>> then?  It would be easy to add, if we think it's worth it.
>
> An alternative would be to document that you can drop "template1" and
> create it again using the ICU collation rules you need.
>
> But I'd prefer an "initdb" option.

Ok, here is a version with an initdb option and also a createdb option
(to expose the CREATE DATABASE option).

You can mess with people by setting up your databases like this:

initdb -D data --locale-provider=icu --icu-rules='&a < c < b < e < d'

;-)