Re: Postgres 12: backend crashes when creating non-deterministiccollation

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