dupes for PK and other UNIQUE indexes - Mailing list pgsql-admin

From Kevin Kempter
Subject dupes for PK and other UNIQUE indexes
Date
Msg-id 200911011022.21062.kevink@consistentstate.com
Whole thread Raw
Responses Re: dupes for PK and other UNIQUE indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi all;

I have a client with a table which has an exeedingly large amount of bloat, so
we plan to rebuild the table.  However in setting up a test box I've found
that both the PK and another UNIQUE index column have duplicate values.

In theory the INDEX/PK should refuse to build if dupes exist on the data, and
subsequent data should refuse to load if the PK/UNIQUE index already exists.

Anyone have any Idea how this could happen?

Thanks in advance

pgsql-admin by date:

Previous
From: Anj Adu
Date:
Subject: Re: pg_autovacuum entries
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_autovacuum entries