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 ?
>
>
>
>
>
>
>