Re: Drop foreign key replication problem

2003-12-03 Thread Heikki Tuuri
Batara, thank you for the bug report. I have to fix this bug when I overhaul the foreign key constraint naming conventions. Yes, to fix the problem you can drop the foreign key constraint manually in the slave. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transacti

Re: Drop Foreign Key

2003-06-27 Thread Nils Valentin
Hi Nico, I understood that DROP FOREIGN KEY is not supported before Version 4.0.13. ( In such case you will have to drop the table and recreate it.) Best regards Nils Valentin Tokyo/Japan 2003年 6月 27日 金曜日 16:45、Nico Gr さんは書きました: > Hello, > > how can i delete an foreign key between two tables?

Re: Drop Foreign Key

2003-06-27 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-27 09:45:06 +0200: > how can i delete an foreign key between two tables? Is there a drop foreign > key - command available? yes, read: http://www.innodb.com/ibman.html#InnoDB_foreign_keys -- If you cc me or remove the list(s) completely I'll most likely ign