I have a big table referenced by other tables and need to split the table on several parts.
- I create table by
CREATE TABLE product_part0 () INHERITS (product);
- Move some rows to
INSERT INTO product_part0 SELECT * FROM ONLY product ORDER BY id LIMIT 200;
- Now I need to remove duplicates from master-table. Run
DELETE FROM ONLY product WHERE id IN (SELECT id FROM product_part0);
ERROR: update or delete on table "product" violates foreign key constraint "product_id_refs" on table "searchcache" DETAIL: Key (id)=(13375) is still referenced from table "searchcache".
So, how to delete duplicate rows?
I made similar question at postgresql maillist.