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

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Duplicate primary key and also the OID !!!!
Дата
Msg-id b6sse7$2rh9$1@news.hub.org
обсуждение исходный текст
Ответ на Duplicate primary key and also the OID !!!!  ("Gaetano Mendola" <mendola@bigfoot.com>)
Список 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 по дате отправления:

Предыдущее
От: Patrick Meylemans
Дата:
Сообщение: compile version 7.3.2 --with-CXX
Следующее
От: "Nikolaus Dilger"
Дата:
Сообщение: Re: Trying to Tunning DB