From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: andrewbille@gmail.com
Subject: BUG #17170: Invalid collation created with provider icu and initdb' locale C
Date: Tue, 31 Aug 2021 07:15:54 +0000
Message-ID: <17170-95845cf3f0a9c36d@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17170
Logged by: Andrew Bille
Email address: andrewbille@gmail.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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, andrewbille@gmail.com
Subject: Re: BUG #17170: Invalid collation created with provider icu and initdb' locale C
In-Reply-To: <17170-95845cf3f0a9c36d@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox