Re: CREATE COLLATION must be specified
| От | jian he |
|---|---|
| Тема | Re: CREATE COLLATION must be specified |
| Дата | |
| Msg-id | CACJufxER70bX_0_BWX+Wk_RFDS8hjOyCoDTWNs98RYFODQc2_Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: CREATE COLLATION must be specified (Peter Eisentraut <peter.eisentraut@enterprisedb.com>) |
| Список | pgsql-hackers |
--ok
CREATE COLLATION some_collation (
PROVIDER = icu,
LOCALE = 'en-u-ks-primary',
DETERMINISTIC = FALSE
);
PROVIDER = icu,
LOCALE = 'en-u-ks-primary',
DETERMINISTIC = FALSE
);
CREATE COLLATION some_collation1 (
PROVIDER = icu,
LC_COLLATE = 'en-u-ks-primary',
LC_CTYPE = 'en-u-ks-primary',
DETERMINISTIC = FALSE
);
--ERROR: parameter "locale" must be specified
CREATE COLLATION some_collation2 (
LC_COLLATE = 'en-u-ks-primary',
LC_CTYPE = 'en-u-ks-primary',
LOCALE = 'en-u-ks-primary',
PROVIDER = icu,
DETERMINISTIC = FALSE
);
--ERROR: conflicting or redundant options
--DETAIL: LOCALE cannot be specified together with LC_COLLATE or LC_CTYPE.
LC_COLLATE = 'en-u-ks-primary',
LC_CTYPE = 'en-u-ks-primary',
LOCALE = 'en-u-ks-primary',
PROVIDER = icu,
DETERMINISTIC = FALSE
);
--ERROR: conflicting or redundant options
--DETAIL: LOCALE cannot be specified together with LC_COLLATE or LC_CTYPE.
Since LC_COLLATE is bundled together with LC_CTYPE.
In 15, If the provider is ICU then LC_COLLATE and LC_CTYPE are no longer required?
On Sat, May 28, 2022 at 11:55 PM Peter Eisentraut <peter.eisentraut@enterprisedb.com> wrote:
On 28.05.22 20:16, Shay Rojansky wrote:
> 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).
This change is intentional, but the documentation could be improved.
--
I recommend David Deutsch's <<The Beginning of Infinity>>
Jian
В списке pgsql-hackers по дате отправления: