Am 04.10.19 um 12:13 schrieb Thomas Kellerer:
> 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
> 2019-10-04 11:54:23 CEST DETAIL: Failed process was running:
> CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu',
> deterministic = false)
> 2019-10-04 11:54:23 CEST HINT: See C include file "ntstatus.h" for
> a description of the hexadecimal value.
> 2019-10-04 11:54:23 CEST LOG: terminating any other active server
> processes
> 2019-10-04 11:54:23 CEST WARNING: terminating connection because of
> crash of another server process
> 2019-10-04 11:54:23 CEST DETAIL: The postmaster has commanded this
> server process to roll back the current transaction and exit, because
> another server process exited abnormally and possibly corrupted shared
> memory.
>
> This is on Windows 10 with the Postgres 12 binaries from EDB.
> Exact Postgres version is: PostgreSQL 12.0, compiled by Visual C++
> build 1914, 64-bit
> The database was pg_upgraded if that makes any difference
>
>
works for me, with:
psql (12rc1 (Ubuntu 12~rc1-1.pgdg18.04+1))
Type "help" for help.
test=# CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu',
deterministic = false);
CREATE COLLATION
test=*# commit;
COMMIT
test=#
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com