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

Thomas Kellerer wrote:
> I was trying to learn how the new non-deterministic collations in v12
> work, but the following makes the backend crash:
>
> CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu',
> deterministic = false);
>
> Which leads to:
>
> 2019-10-04 11:54:23 CEST LOG: server process (PID 7540) was
> terminated by exception 0xC0000005
>
> I might have misunderstood how to use deterministic to create a case-
> insensitive collation, but I don't think the backend should crash if
> I do something wrong ;)

Yes, there is a bug somewhere. FWIW, it works on my Linux system.

To get a case insensitive collation you'd have to use something like

LOCALE = 'de-DE-u-ks-level2'

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com