Re: Innodb Foreign Key Problems.

Scott, http://www.innodb.com/ibman.html#InnoDB_foreign_keys " Starting from version 3.23.50 you can also associate the ON DELETE CASCADE or ON DELETE SET NULL clause with the foreign key constraint. Corresponding ON UPDATE options are available starting from 4.0.8. " Regards, Heikki Innobase Oy

Re: InnoDB foreign key problems - is Heikki out there?

Hi! Please send your postings to [EMAIL PROTECTED] The newsgroup mailing.database.mysql is only a mirror of that mailing list. The error message below is misleading. It should really be 'Cannot update a parent row...'. Internally InnoDB does the update by deleting and reinserting the index record