MySQL Forums
Forum List  »  Triggers

Trigger bug in 5.019: drop doesn't work
Posted by: Marc Van Olmen
Date: April 11, 2006 03:06PM

I'm doing the following command:

DROP TRIGGER trig_t_attribute_value_lnk_media_update;


get's error:

ERROR 1146 (42S02): Table 'tvplanner5.T_ATTRIBUTE_VALUE' doesn't exist

creating the trigger afterwards that

gives error ERROR 1359 (HY000): Trigger already exists


so I created a new trigger function with a new name and that one works fine...

not sure why I can't use name 'trig_t_attribute_value_lnk_media_update' anymore.

doing


SHOW TRIGGERS; doesn't show any triggers (except the new one I just created)

I restarted my computer and the error still stays.

regards,

Mvo

Options: ReplyQuote


Subject
Views
Written By
Posted
Trigger bug in 5.019: drop doesn't work
2967
April 11, 2006 03:06PM


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.