MySQL Forums
Forum List  »  Triggers

Re: Forceing abort of delete via trigger
Posted by: Roland Bouman
Date: August 02, 2005 12:32PM

Alas, it's not possible in a clean way. Check out this thread:

http://forums.mysql.com/read.php?99,22523

You can force some other, unrelated error (insert a duplicate in your favourite, especially for this purpose created table).


BTW, maybe you can do this with a view WITH CHECK OPTION. You wont get any errors if the conditions are violated, but you can rely on the action to abort.



Edited 1 time(s). Last edit at 08/02/2005 12:36PM by Roland Bouman.

Options: ReplyQuote


Subject
Views
Written By
Posted
6409
August 01, 2005 02:11PM
Re: Forceing abort of delete via trigger
3625
August 02, 2005 12:32PM


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.