Re: Mixed Locales and Upgrading - Mailing list pgsql-general

From Don Seiler
Subject Re: Mixed Locales and Upgrading
Date
Msg-id CAHJZqBDC1Qdse+GVUn0CrVh+_f5dRPSNnqwRw_6WSy=1AhvEAQ@mail.gmail.com
Whole thread Raw
In response to Re: Mixed Locales and Upgrading  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Mixed Locales and Upgrading  (Don Seiler <don@seiler.us>)
List pgsql-general
On Mon, Mar 30, 2020 at 4:30 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Don Seiler <don@seiler.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.

That's what I was hoping to hear. Thanks!

Don.

--
Don Seiler
www.seiler.us

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Mixed Locales and Upgrading
Next
From: Kevin Brannen
Date:
Subject: RE: Is PostgreSQL SQL Database Command Syntax Similar toMySQL/MariaDB?