Hi,
I am having regurlarly duplicated rows with the same primary key.
=> select id, created_at, updated_at from tracks where created_at =
'2014-07-03 15:09:16.336488';
id | created_at | updated_at
++
331
35 GMT+02:00 Alban Hertroys :
> On 09 Aug 2014, at 11:38, Alexis Bernard wrote:
>
> > Hi,
> >
> > I am having regurlarly duplicated rows with the same primary key.
> >
> > => select id, created_at, updated_at from tracks where created_at =
> &#
Hi,
Thanks for your help Alban !
Alexis.
2014-08-09 18:46 GMT+02:00 Alban Hertroys :
> On 09 Aug 2014, at 13:24, Alexis Bernard wrote:
>
> > Primary key definition: "tracks_pkey" PRIMARY KEY, btree (id)
> > select version(): PostgreSQL 9.3.4 on x86_64-unknown-
The vacuum full tracks just finished and I still have the duplicated IDs.
2014-08-12 9:17 GMT+02:00 Alexis Bernard :
> Hi,
>
> Thanks for your help Alban !
>
> Alexis.
>
>
> 2014-08-09 18:46 GMT+02:00 Alban Hertroys :
>
> On 09 Aug 2014, at 13:24, Alexis Berna
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 :
> On 8/12/2014 12:32 AM, Alexis Bernard wrote:
>
>> The vacuum full tracks just finished an
