Re: Mixed Locales and Upgrading

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Don Seiler <don(at)seiler(dot)us>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Mixed Locales and Upgrading
Date: 2020-03-30 21:30:32
Message-ID: 1505.1585603832@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Don Seiler <don(at)seiler(dot)us> writes:
> Actually, would I need to re-index on text columns that we know contain
> UUID strings? UUID characters seem to be pretty basic alphanumeric ASCII
> characters.

I think you're all right with respect to those, since they're the
same under any encoding. It's columns containing non-ASCII characters
that you'd want to worry about reindexing.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Don Seiler 2020-03-30 21:39:32 Re: Mixed Locales and Upgrading
Previous Message Don Seiler 2020-03-30 20:36:16 Re: Mixed Locales and Upgrading