1. You have to remove foreign key reference from table searchcache.
2. take backup of data from searchcache.
3. create partition of table product
4. add constraints on table searchcache.(if necessary delete and create
searchcache after taking backup.)
-
Thanks and Regards,
Sachin Kotwal
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
