Re: Duplicate primary key and also the OID !!!!

begin;
create table temp as select distinct * from user_traffic WHERE id_user =
6738;
delete from user_traffic WHERE id_user = 6738;
insert into user_traffic select * from temp;
drop table temp;
commit;

C.

Gaetano Mendola wrote, On 4/6/2003 2:17 PM:
> 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 ?
>
>
>
>
>
>
>