dupes for PK and other UNIQUE indexes

Поиск
Список
Период
Сортировка
От Kevin Kempter
Тема dupes for PK and other UNIQUE indexes
Дата
Msg-id 200911011022.21062.kevink@consistentstate.com
обсуждение исходный текст
Ответы Re: dupes for PK and other UNIQUE indexes
Список 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 по дате отправления:

Предыдущее
От: Anj Adu
Дата:
Сообщение: Re: pg_autovacuum entries
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_autovacuum entries