CREATE COLLATION must be specified

From: Shay Rojansky <roji(at)roji(dot)org>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: CREATE COLLATION must be specified
Date: 2022-05-28 18:16:40
Message-ID: CADT4RqCZS-410nAcCF1nqYJcBrLL17dT3PT7XtxL_nHkc+fZEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

Testing on the PG15 beta, I'm getting new failures when trying to create a
collation:

CREATE COLLATION some_collation (LC_COLLATE = 'en-u-ks-primary',
LC_CTYPE = 'en-u-ks-primary',
PROVIDER = icu,
DETERMINISTIC = False
);

This works on PG14, but on PG15 it errors with 'parameter "locale" must be
specified'.

I wanted to make sure this breaking change is intentional (it doesn't seem
documented in the release notes or in the docs for CREATE COLLATION).

Shay

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2022-05-28 18:25:20 Re: CREATE COLLATION must be specified
Previous Message Daniel Verite 2022-05-28 17:18:51 Re: ICU_LOCALE set database default icu collation but not working as intended.