Duplicate primary key and also the OID !!!!

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Duplicate primary key and also the OID !!!!
Date: 2003-04-06 12:17:59
Message-ID: b6p5qd$1jui$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-04-06 16:59:08 Re: Duplicate primary key and also the OID !!!!
Previous Message Cristina Surroca 2003-04-05 14:01:24 Trying to Tunning DB