On 07/12/2017 11:25 PM, Tom Lane wrote:
> rihad <rihad@mail.ru> writes:
>> What if only English letters are used in the textual indices (ascii
>> 0-127), would they still be impacted after datctype&datcollate
>> "C"->"en_US.UTF-8" change?
> Yes, as even minimal testing would have told you. C sort order is
> more case-sensitive, for instance.
>
> regards, tom lane
> .
>
Btw, can we wrap the update of datcollate &datctype and rebuilding of
textual indices inside a transaction with effectively 0 downtime?