dupes for PK and other UNIQUE indexes

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: dupes for PK and other UNIQUE indexes
Date: 2009-11-01 17:22:20
Message-ID: 200911011022.21062.kevink@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2009-11-01 17:55:57 Re: pg_autovacuum entries
Previous Message Anj Adu 2009-11-01 16:41:10 Re: pg_autovacuum entries