Re: Postgres 12: backend crashes when creating non-deterministic collation

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(at)colStrength=secondary'
>
> If you use that in your example, the case insensitive lookups should
> work.

That indeed works, thanks a lot.