Postgres Pro
Downloads
Home   >   mailing lists

Re: Default collation changes leave indexes in invalid state - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Default collation changes leave indexes in invalid state
Date
Msg-id 31133.1568209167@sss.pgh.pa.us
Whole thread Raw
In response to Default collation changes leave indexes in invalid state  (Vincent Van Driessche <vincent@dabble.be>)
Responses Re: Default collation changes leave indexes in invalid state
List pgsql-bugs
Tree view 
Vincent Van Driessche <vincent@dabble.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

pgsql-bugs by date:

Previous
From: Sandeep Thakkar
Date:
Subject: Re: Postgres 11.5.1 failed installation
Next
From: Vincent Van Driessche
Date:
Subject: Re: Default collation changes leave indexes in invalid state