MySQL Forums
Forum List  »  Triggers

I can't drop tigger
Posted by: Luki
Date: October 27, 2005 07:31AM

I have trigger:
CREATE TRIGGER tmq_set_severity AFTER INSERT ON stat_mq_queues
FOR EACH ROW BEGIN
:
:
:
END;

For long time everythink was ok. But now I can't do:
select * from stat_mq_queues;
answer is:
ERROR 1415 (0A000): Not allowed to return a result set from a trigger
When I want:
DROP TRIGGER tmq_set_severity;
answer is "ERROR 1415 (0A000): Not allowed to return a result set from a trigger" too.
What's going on? Could somebody help me?

My server version: 5.0.13-rc-Debian_0.dotdeb.1-log

Thanks Luki

Options: ReplyQuote


Subject
Views
Written By
Posted
I can't drop tigger
2885
October 27, 2005 07:31AM


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.