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

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Duplicate primary key and also the OID !!!!
Date: 2003-04-07 23:58:25
Message-ID: b6sse7$2rh9$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


"CoL" <col(at)mportal(dot)hu> wrote in message news:b6sfho$1b7d$1(at)news(dot)hub(dot)org(dot)(dot)(dot)
> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nikolaus Dilger 2003-04-08 03:50:42 Re: Trying to Tunning DB
Previous Message David Wendy 2003-04-07 20:31:11 Speed up a query - using a temp table