MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: Trigger already exists error, but not in information_schema
Posted by: Alex mashtakov
Date: May 20, 2006 03:57AM

Hi folks,

I've got the similar problem. I had a table - table1 with
a trigger tr_table1. When I altered a table structure (increase varchar size for one column) - the trigger
dissapeared from SHOW TRIGGERS.

When I tried to re-create it with the same name - I got
the same message "Trigger already exists".

It was impossible to create trigger with the same name even after I dropped and re-created the table1.

Strange ...

PS:
5.0.19-linux




Edited 2 time(s). Last edit at 05/20/2006 04:58AM by Alex mashtakov.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Trigger already exists error, but not in information_schema
8258
Jean Moniatte
April 21, 2006 11:31PM
Re: Trigger already exists error, but not in information_schema
3240
Alex mashtakov
May 20, 2006 03:57AM
Re: Trigger already exists error, but not in information_schema
2879
Dmitri Lenev
May 31, 2006 05:12AM


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.