rihad <rihad(at)mail(dot)ru> writes:
> On 07/10/2017 11:07 PM, Tom Lane wrote:
>> ... which that isn't. I'd suggest checking for indexes that might need
>> to be rebuilt with this query borrowed from the regression tests:
> I ran the query on our production database. Zero results.
Really? You have no indexes on textual columns? That seems surprising.
> Do I have the green light to
> set datcollate='en_US.UTF-8', datctype='en_US.UTF-8'
Well, I'd double-check that result, but I suppose you can always reindex
later if you find you missed something.
regards, tom lane