MySQL Forums
Forum List  »  Partitioning

foreign key in partition
Posted by: harry singh
Date: December 24, 2010 06:02AM

Dear Sir/Madam

I have make the partition on table this table consist of the many foreign key from other table primary keys and another this table primary key familiar with another table such as a foreign key

When making then show the error:---

#1217 --> Cannot delete or update a parent row: a foreign key constraint fails

in short can we make the partition in foreign key tables

Options: ReplyQuote

Written By
foreign key in partition
December 24, 2010 06:02AM
December 24, 2010 11:09AM
December 25, 2010 01:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.