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.
- pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE ind... rihad
- Re: pg_upgrading to 10.1 corrupts (varchar,varchar) U... Magnus Hagander
- Re: pg_upgrading to 10.1 corrupts (varchar,varchar) U... Laurenz Albe
- pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQU... rihad
- Re: pg_upgrading to 10.1 corrupts (varchar,varcha... Peter Geoghegan
- Re: pg_upgrading to 10.1 corrupts (varchar,va... rihad
- Re: pg_upgrading to 10.1 corrupts (varchar,va... rihad
- Re: pg_upgrading to 10.1 corrupts (varcha... Peter Geoghegan
- Re: pg_upgrading to 10.1 corrupts (v... rihad
- Re: pg_upgrading to 10.1 corrupt... Peter Geoghegan
- Re: pg_upgrading to 10.1 cor... rihad
- Re: pg_upgrading to 10.1 cor... Peter Geoghegan
- Re: pg_upgrading to 10.1 corrupts (varchar,varchar) U... rihad