Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade fails to preserve old versions of the predefined collations - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: pg_upgrade fails to preserve old versions of the predefined collations
Date
Msg-id CA+hUKG+6MWf4DKq6KGDOe4xOnOAu9KDH_7CDonKvjvKOZtdz9Q@mail.gmail.com
Whole thread Raw
In response to pg_upgrade fails to preserve old versions of the predefinedcollations  (Alexander Lakhin <exclusion@gmail.com>)
Responses Re: pg_upgrade fails to preserve old versions of the predefinedcollations  (Alexander Lakhin <exclusion@gmail.com>)
List pgsql-hackers
Tree view 
On Fri, Nov 29, 2019 at 9:08 AM Alexander Lakhin <exclusion@gmail.com> wrote:
> So for now it seems dangerous to use predefined collations as their old
> versions are not preserved by pg_upgrade and the user doesn't know which
> indexes affected by the actual ICU collation changes.

Yeah, we noticed this while working on a proposal for new
per-database-object version dependency tracking, and Peter E has
written a patch to address it:

https://commitfest.postgresql.org/25/2328/

pgsql-hackers by date:

Previous
From: Alexander Lakhin
Date:
Subject: pg_upgrade fails to preserve old versions of the predefinedcollations
Next
From: Alexander Lakhin
Date:
Subject: Re: pg_upgrade fails to preserve old versions of the predefinedcollations