Re: Postgres 12: backend crashes when creating non-deterministiccollation - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Postgres 12: backend crashes when creating non-deterministiccollation
Date
Msg-id 766457be-2ac6-1edf-cb8d-3525c7c47f22@gmx.net
Whole thread Raw
In response to Re: Postgres 12: backend crashes when creating non-deterministic collation  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
Daniel Verite schrieb am 04.10.2019 um 18:49:
>> Creating works, but apparently on Windows ICU does not support this.
>
> After installing v12 on windows with the EDB installer, I notice
> that it ships with ICU 53, a relatively old version (2014).
>
> Concerning the problem just above (not the crash), ICU 53 is too old
> to support BCP47 tags as collation attributes, as mentioned
> at https://www.postgresql.org/docs/12/collation.html :
>
>    "The first example selects the ICU locale using a “language tag” per
>    BCP 47. The second example uses the traditional ICU-specific locale
>    syntax. The first style is preferred going forward, but it is not
>    supported by older ICU versions.
>
> With ICU 53 or older, instead of the locale above, we must use the
> old-style syntax:
>
>   locale = 'de-DE@colStrength=secondary'
>
> If you use that in your example, the case insensitive lookups should
> work.

That indeed works, thanks a lot.




pgsql-general by date:

Previous
From: Moreno Andreo
Date:
Subject: Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparentwraparound
Next
From: Adrian Klaver
Date:
Subject: Re: psql \copy hanging