Re: Default collation changes leave indexes in invalid state

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vincent Van Driessche <vincent(at)dabble(dot)be>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Default collation changes leave indexes in invalid state
Date: 2019-09-11 13:39:27
Message-ID: 31133.1568209167@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Vincent Van Driessche <vincent(at)dabble(dot)be> writes:
> ... By running it before and after changing the `C` collation into `en_US.UTF-8`:
> UPDATE pg_database SET datcollate='en_US.UTF-8', datctype='en_US.UTF-8'

That is not, and I do not think ever will be, a supported operation.
If it breaks your database it's your own fault.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Vincent Van Driessche 2019-09-11 14:07:07 Re: Default collation changes leave indexes in invalid state
Previous Message Sandeep Thakkar 2019-09-11 08:12:45 Re: Postgres 11.5.1 failed installation