pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices

From: rihad <rihad(at)mail(dot)ru>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Date: 2017-12-22 11:56:30
Message-ID: f73b25e8-2d15-b23b-609a-4e48241910a5@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I forgot to mention the real problem: the mentioned unique constraint
didn't work and allowed duplicate rows to get inserted into the table
until the duplicates were manually removed the the index was rebuilt.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2017-12-22 13:09:45 Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Previous Message rihad 2017-12-22 11:53:12 pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices