Re: Duplicated IDs
| От | Alexis Bernard |
|---|---|
| Тема | Re: Duplicated IDs |
| Дата | |
| Msg-id | CANiB9R937KmvWtZm-ehrUU+z79mhwkrsseCP6J5JAERix8WQGQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Duplicated IDs (John R Pierce <pierce@hogranch.com>) |
| Список | pgsql-general |
I re-tried both vacuum and reindex:
=> vacuum full verbose tracks;
INFO: vacuuming "public.tracks"
INFO: "tracks": found 0 removable, 1662221 nonremovable row versions in 34274 pages
DETAIL: 0 dead row versions cannot be removed yet.
CPU 0.27s/0.68u sec elapsed 2.44 sec.
VACUUM
=> reindex index tracks_pkey;
ERROR: could not create unique index "tracks_pkey"
DETAIL: Key (id)=(793935) is duplicated.
2014-08-12 20:21 GMT+02:00 John R Pierce <pierce@hogranch.com>:
On 8/12/2014 12:32 AM, Alexis Bernard wrote:vacuum full does a reindex, the reindex should have errored out on the duplicate ID's.The vacuum full tracks just finished and I still have the duplicated IDs.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: