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 <pie...@hogranch.com>: > On 8/12/2014 12:32 AM, Alexis Bernard wrote: > >> The vacuum full tracks just finished and I still have the duplicated IDs. >> > > vacuum full does a reindex, the reindex should have errored out on the > duplicate ID's. > > > > -- > 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 >
