CREATE COLLATION must be specified - Mailing list pgsql-hackers

From Shay Rojansky
Subject CREATE COLLATION must be specified
Date
Msg-id CADT4RqCZS-410nAcCF1nqYJcBrLL17dT3PT7XtxL_nHkc+fZEQ@mail.gmail.com
Whole thread Raw
Responses Re: CREATE COLLATION must be specified  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List 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

pgsql-hackers by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: ICU_LOCALE set database default icu collation but not working as intended.
Next
From: Peter Eisentraut
Date:
Subject: Re: CREATE COLLATION must be specified