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

From Don Seiler
Subject Re: Mixed Locales and Upgrading
Date
Msg-id CAHJZqBBPf_peA40ZswtcYaj5OA0OxynJxKqVs57sARzEe45QtA@mail.gmail.com
Whole thread Raw
In response to Re: Mixed Locales and Upgrading  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Mixed Locales and Upgrading  (Don Seiler <don@seiler.us>)
List pgsql-general
On Tue, Mar 17, 2020 at 9:25 PM Michael Paquier <michael@paquier.xyz> wrote:

There is no way to know how much indexes would get broken without
having a look at it.  Anything ASCII-based should be of no problem.
If you have a doubt, reindexing evey index which includes text column
data is the best course of action in my opinion if you have any
doubts, because that's safe even if it has a higher cost.

Here's the fun part. A lot of the tables use UUIDv4 strings for primary keys. However these are stored in text/varchar columns.

--
Don Seiler
www.seiler.us

pgsql-general by date:

Previous
From: Matt Magoffin
Date:
Subject: Re: Duplicate key violation on upsert
Next
From: pabloa98
Date:
Subject: Re: Could postgres12 support millions of sequences? (like 10 million)