Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: rihad <rihad(at)mail(dot)ru>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Date: 2017-12-22 15:43:27
Message-ID: CAH2-Wzm0efDJQkCFhgBH_L2QX0=tqa-URB-n++-NvhOVM-PPjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have no idea. Maybe something to do with not actually using the same
collation provider?

The freebsd package contains modifications to make icu work, or at least
did. Possibly, you just stopped using the same collation provider, without
even realizing it, because they switched over to a new provider without
accounting for pg_upgrade. If so, then that's a bug in the package. This is
a total speculation, but makes a certain amount of sense to me.

--
Peter Geoghegan
(Sent from my phone)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rihad 2017-12-22 15:52:20 Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Previous Message rihad 2017-12-22 15:18:10 Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices