Trigger bug in 5.019: drop doesn't work
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
Subject
Views
Written By
Posted
Trigger bug in 5.019: drop doesn't work
2967
April 11, 2006 03:06PM
1688
April 19, 2006 03:07PM
1786
April 19, 2006 03:11PM
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.