MySQL Forums
Forum List  »  Federated Storage Engine

Advanced Search
New Topic

Foreign keys refering to primary keys in Federated table
Posted by: Arun Kumar Boppudi
Date: April 08, 2009 05:39AM

I have created a table with FEDERATED engine. And also it has primary key. When I trying to create a new table with foreign key that refers to the primary key in federated table, I am getting an error.

I have a InnoDB table. Created a foreign key in it, referring to federated table(referring to a InnoDB table on a different Host) primary key.

Will it work?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Foreign keys refering to primary keys in Federated table
7825
Arun Kumar Boppudi
April 08, 2009 05:39AM


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.