BUG #17170: Invalid collation created with provider icu and initdb' locale C

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: andrewbille(at)gmail(dot)com
Subject: BUG #17170: Invalid collation created with provider icu and initdb' locale C
Date: 2021-08-31 07:15:54
Message-ID: 17170-95845cf3f0a9c36d@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17170
Logged by: Andrew Bille
Email address: andrewbille(at)gmail(dot)com
PostgreSQL version: 14beta3
Operating system: centos-7
Description:

Hi!
When using postgres built "--with-icu" I get an invalid collation with the
following script:
initdb -D db --locale=C
createdb testdb
psql testdb -c "CREATE COLLATION test (provider=icu,
locale='en_US.utf8');"
psql testdb -c "SELECT 'a' < 'b' COLLATE test;"
ERROR: collation "test" for encoding "SQL_ASCII" does not exist
LINE 1: SELECT 'a' < 'b' COLLATE test;
^
or
psql testdb -c "DROP COLLATION test;"
ERROR: collation "test" for encoding "SQL_ASCII" does not exist

Reproduced on REL_10_STABLE..REL_14_STABLE.

Thanks!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-08-31 09:25:58 BUG #17171: packages for ppc64
Previous Message Alexander Lakhin 2021-08-31 04:00:00 Re: BUG #17161: Assert failed on opening a relation that exists in two schemas via the LANGUAGE SQL function