Re: Duplicated IDs

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 =
> '2014-07-03 15:09:16.336488';
> id | created_at | updated_at
> --------+----------------------------+----------------------------
> 331804 | 2014-07-03 15:09:16.336488 | 2014-07-03 15:37:55.253729
> 331804 | 2014-07-03 15:09:16.336488 | 2014-07-03 15:37:55.253801
>
> => select id from tracks where id = 331804;
> id
> ----
> (0 rows)
>
> => delete from tracks where created_at = '2014-07-03 15:09:16.336488' and
> updated_at = '2014-07-03 15:37:55.253801';
> ERROR: update or delete on table "tracks" violates foreign key constraint
> "fk_sources_on_track_id" on table "sources"
> DETAIL: Key (id)=(331804) is still referenced from table "sources".
>
> All colums are identical except the updated_at.
>
> PostgreSQL version is 9.3 and fsync is true.
>
> Any idea how I can clean my table? And then how I can stop this?
>
> Cheers,
> Alexis

What happens if you try and delete the older row instead of the newer one?

How does "updated_at" get populated/changed?

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Duplicated-IDs-tp5814311p5814615.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.