Why am I getting "collation attribute X not recognized" in my PostgreSQL database?

Question

I'm running a PostgreSQL 11.22 database, and I want to create a new collation to support the Czech language, since I don't see it on the collations list when I select from pg_catalog.

Attempt 1 The documentation claims it is possible to create a collation basing it off of libc like so:

CREATE COLLATION czech (provider = libc, locale = 'cs_CZ'); But I got: ERROR: could not create locale "cs_CZ": No such file or directory
DETAIL: The operating system could not find any locale data for the locale name "cs_CZ".

Attempt 2 After that, I tried creating a custom collation, in which I could manually set the Czech language's collation rules, like so:

CREATE COLLATION IF NOT EXISTS czech (provider = icu, locale = 'und', rules = '...');

But I got the error

ERROR: collation attribute "rules" not recognized LINE 2: ...OT EXISTS custom (provider = icu, locale = 'und', rules = '...

Do I have an incorrect version of PostgreSQL? Is that a newer feature, or does something else need to be configured?

Laurenz Albe · Accepted Answer · 2024-10-11 04:29:06Z

2

For the first question, you first have to make sure that the C library has a collation with that name for your current encoding. After you create or install new C library collations, you have to import them into PostgreSQL with

SELECT pg_import_system_collations('pg_catalog');

For the second question, the RULES clause does not exist in the unsupported version 11 of PostgreSQL.

answered Oct 11, 2024 at 4:29

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why am I getting "collation attribute X not recognized" in my PostgreSQL database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related