Hi all, I'm running postgres 7.3.2 and in a table with a primary key I got that primary key duplicated :-(
I found this because each time that I try tu update the field with id_user_traffic = 11348 I obtain an error about key duplicated. SELECT oid, id_user_traffic, start_date, end_date FROM user_traffic WHERE id_user = 6738; oid | id_user_traffic | start_date | end_date ---------+-----------------+------------+------------ 1213776 | 11348 | 2003-03-07 | 2003-04-07 1213776 | 11348 | 2003-03-07 | 2003-04-07 1213776 | 11348 | 2003-03-07 | 2003-04-07 1213776 | 11348 | 2003-03-07 | 2003-04-07 1107090 | 9675 | 2003-01-17 | 2003-02-17 1213779 | 11349 | 2003-04-07 | 2003-05-07 1213782 | 11350 | 2003-05-07 | 2003-06-07 How is it possible have the oid and the id_user_traffic ( serial primary key ) duplicated ? Any idea ? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster