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'
;-)