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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
