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
