Re: Duplicate primary key and also the OID !!!! - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Duplicate primary key and also the OID !!!!
Date
Msg-id b6sse7$2rh9$1@news.hub.org
Whole thread Raw
In response to Duplicate primary key and also the OID !!!!  ("Gaetano Mendola" <mendola@bigfoot.com>)
List pgsql-admin
"CoL" <col@mportal.hu> wrote in message news:b6sfho$1b7d$1@news.hub.org...
> 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;


Is not so easy like this...
After that delete some other records in
other tables will be deleted ( cascade ).

The solution was doing the dump, modify
by hand the dump, reinit the DB ........


Thank you anyway.

Gaetano


pgsql-admin by date:

Previous
From: Patrick Meylemans
Date:
Subject: compile version 7.3.2 --with-CXX
Next
From: "Nikolaus Dilger"
Date:
Subject: Re: Trying to Tunning DB