On 07/12/2017 11:25 PM, Tom Lane wrote:
rihad <rihad@xxxxxxx> 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?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
