Re: Duplicated IDs

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(at)hogranch(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>