R
R
resident2015-10-09 15:42:09
MySQL
resident, 2015-10-09 15:42:09

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

1 answer(s)
M
Melkij, 2015-10-09
@resident

Unfortunately, you can't.
https://dev.mysql.com/doc/refman/5.6/en/partitioni...

Foreign keys not supported for partitioned InnoDB table

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question