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@xxxxxxxxxxxx>:
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
