CREATE COLLATION without LOCALE throws error in v15

Поиск
Список
Период
Сортировка
От Kyle Spearrin
Тема CREATE COLLATION without LOCALE throws error in v15
Дата
Msg-id CALDQics_oBEYfOnu_zH6yw9WR1waPCmcrqxQ8+39hK3Op=z2UQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: CREATE COLLATION without LOCALE throws error in v15
Список pgsql-bugs
Дерево обсуждения
Hi,
I wanted to report a bug with the CREATE COLLATION query in Postgres 15.

The following query works in Postgres 12-14:

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

However, in Postgres 15 we see the following error:

ERROR: parameter "locale" must be specified

Changing the query to following resolves the issue:

CREATE COLLATION "postgresIndetermanisticCollation" (LOCALE = 'en-u-ks-primary',
    PROVIDER = icu,
    DETERMINISTIC = False
);

According to the docs here, we should be able to execute this query either way (as is evident when testing in versions 11-14).

This causes problems with queries generated by our Entity Framework Core ORM tool that uses npgsql. We don't have control to change the way the COLLATION query is created, therefore preventing us from supporting Postgres 15.

--
Kyle Spearrin

Follow Bitwarden on social media:

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: Bug in jsonb_path_exists (maybe _match) one-element scalar/variable jsonpath handling
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Bug in jsonb_path_exists (maybe _match) one-element scalar/variable jsonpath handling