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
);

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.

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 по дате отправления:

Предыдущее
От: "shiy.fnst@fujitsu.com"
Дата:
Сообщение: RE: Hash index build performance tweak from sorting
Следующее
От: Peter Smith
Дата:
Сообщение: Re: Skipping schema changes in publication