Answer the question
In order to leave comments, you need to log in
Is it possible to partition a table with restrictions on Foreign Keys?
There is a table with foreign key constraints, when trying to partition it gives an error: ERROR: Error 1217: Cannot delete or update a parent row: a foreign key constraint fails. The field on which partitioning is performed is not limited by the foreign key. Or in the partitioned tables it is generally impossible to use foreign keys?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question