Re: postgresql database use a case insensitive collation

Поиск
Список
Период
Сортировка
От jian he
Тема Re: postgresql database use a case insensitive collation
Дата
Msg-id CACJufxFwv9TUHqwqc9c9WcD=toVsf7+vQFLHb=PZB+6M5w6mVQ@mail.gmail.com
обсуждение исходный текст
Ответ на postgresql database use a case insensitive collation  (Dennis <daslaner@gmail.com>)
Список pgsql-admin
Дерево обсуждения

Hi,
You cannot set database-wise case-insensitive collation. Since case insensitiveness is nondeterministic comparisons.

CREATE DATABASE ma page pg 15 quote
There is currently no option to use a database locale with nondeterministic comparisons (see CREATE COLLATION for an explanation). If this is needed, then per-column collations would need to be used.

You can also check: https://www.postgresql.org/docs/15/collation.html (section 24.2.2.4)


On Wed, May 25, 2022 at 11:49 AM Dennis <daslaner@gmail.com> wrote:
Hi,

How to make configuration my postgresql database use a case insensitive collation?

Dennis


--
 I recommend David Deutsch's <<The Beginning of Infinity>>

  Jian


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

Предыдущее
От: Paul Smith
Дата:
Сообщение: Re: postgresql database use a case insensitive collation
Следующее
От: Vivek Gadge
Дата:
Сообщение: ERROR: found xmin 2706850882 from before relfrozenxid 126900049