Re: Allow tailoring of ICU locales with custom rules - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Allow tailoring of ICU locales with custom rules
Date
Msg-id a085dc4f54f001b30293858c2bf9408562e4eee0.camel@cybertec.at
Whole thread Raw
In response to Re: Allow tailoring of ICU locales with custom rules  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: Allow tailoring of ICU locales with custom rules
List pgsql-hackers
On Mon, 2023-02-06 at 22:16 +0100, Peter Eisentraut wrote:
> Right.  Here is a new patch with this fixed.

Thanks.  I played some more with it, and still are still some missing
odds and ends:

- There is a new option ICU_RULES to CREATE DATABASE, but it is not
  reflected in \h CREATE DATABASE.  sql_help_CREATE_DATABASE() needs to
  be amended.

- There is no way to show the rules except by querying "pg_collation" or
  "pg_database".  I think it would be good to show the rules with
  \dO+ and \l+.

- If I create a collation "x" with RULES and then create a database
  with "ICU_LOCALE x", the rules are not copied over.

  I don't know if that is intended or not, but it surprises me.
  Should that be a WARNING?  Or, since creating a database with a collation
  that does not exist in "template0" doesn't make much sense (or does it?),
  is there a way to forbid that?

Yours,
Laurenz Albe



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: run pgindent on a regular basis / scripted manner
Next
From: Jeff Davis
Date:
Subject: Re: Extensible Rmgr for Table Ams