Re: ICU for global collation

From: Marius Timmer <marius(dot)timmer(at)uni-muenster(dot)de>
To: Daniel Verite <daniel(at)manitou-mail(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, 'Arne Scheffer' <scheffa(at)uni-muenster(dot)de>
Subject: Re: ICU for global collation
Date: 2019-10-08 11:15:57
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi everyone,

like the others before me we (the university of Münster) are happy to
see this feature as well. Thank you this.

When I applied the patch two weeks ago I run into the issue that initdb
did not recognize the new parameters (collation-provider and icu-locale)
but I guess it was caused by my own stupidity.

> When trying databases defined with ICU locales, I see that backends
> that serve such databases seem to have their LC_CTYPE inherited from
> the environment (as opposed to a per-database fixed value).
I am able to recreate the issue described by Daniel on my machine.

Now it works as expected. I just had to update the patch since commit
3f6b3be3 had modified two lines which resulted in conflicts. You find
the updated patch as attachement to this mail.

Best regards,

Marius Timmer

Westfälische Wilhelms-Universität Münster (WWU)
Zentrum für Informationsverarbeitung (ZIV)
Röntgenstraße 7-13
Besucheradresse: Einsteinstraße 60 - Raum 107
48149 Münster
+49 251 83 31158

Attachment Content-Type Size
v1-0002-Add-option-to-use-ICU-as-global-collation-provide_rebased.patch text/x-patch 44.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Antonin Houska 2019-10-08 11:52:57 Re: Transparent Data Encryption (TDE) and encrypted files
Previous Message Nikolay Shaplov 2019-10-08 10:50:23 Re: [PATCH] use separate PartitionedRelOptions structure to store partitioned table options