MySQL Forums
Forum List  »  Triggers

cascading for a composite PK
Posted by: Nata Ovchinnikova
Date: January 12, 2006 02:39PM

Hi, everyone.
I cannot reference a composite PK as FK in child table. I try to write a triger to cascade update and delete. It works. I wonder how to catch any posible error and cancel update or delete in parent table. Hopefully, I made myself clear. I'll thankfull for any help.

Options: ReplyQuote


Subject
Views
Written By
Posted
cascading for a composite PK
2408
January 12, 2006 02:39PM
1719
January 12, 2006 05:41PM


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.