Re: postgresql database use a case insensitive collation

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Dennis <daslaner(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: postgresql database use a case insensitive collation
Date: 2022-05-26 14:38:36
Message-ID: CACJufxFwv9TUHqwqc9c9WcD=toVsf7+vQFLHb=PZB+6M5w6mVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vivek Gadge 2022-05-27 16:50:46 ERROR: found xmin 2706850882 from before relfrozenxid 126900049
Previous Message Paul Smith 2022-05-25 08:43:03 Re: postgresql database use a case insensitive collation