Postgres Pro
Downloads
Home   >   mailing lists

Re: Duplicated IDs - Mailing list pgsql-general

From Alexis Bernard
Subject Re: Duplicated IDs
Date
Msg-id CANiB9R937KmvWtZm-ehrUU+z79mhwkrsseCP6J5JAERix8WQGQ@mail.gmail.com
Whole thread Raw
In response to Re: Duplicated IDs  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
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:
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

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: OIDs for jsonb type
Next
From: Albe Laurenz
Date:
Subject: Re: Postgres 9.3 tuning advice