rihad <rihad@xxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
