Partitioning table with billion row

[nuklea <nuklea@xxxxxxxxx>]

I have a big table referenced by other tables and need to split the table on several parts.

1. I create table by CREATE TABLE product_part0 () INHERITS (product);
2. Move some rows to product_part0 by INSERT INTO product_part0 SELECT * FROM ONLY product ORDER BY id LIMIT 200;
3. Now I need to remove duplicates from master-table. Run DELETE FROM ONLY product WHERE id IN (SELECT id FROM product_part0);

With result:

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?