distal-attribute
distal-attribute
distal-attribute
distal-attribute

show triggers

User, date Message
Written by BubikolRamios
3 years ago
Category: General
326 posts since Thu, 14 Jan 10
show triggers;
/* 0 rows affected, 0 rows found. Duration for 1 query: 0,030 sec. */

False, triggers are there, just don't have (don't know which) privileges to see them. Also triggers are not shown in HSQL tree window, no warnings/errors.

Regards
Written by BubikolRamios
3 years ago
326 posts since Thu, 14 Jan 10
If any comfort (-:, mysql query browser does the same.
Written by ansgar
3 years ago
4801 posts since Fri, 07 Apr 06
If you have no privs to see them what do you expect from Heidi in that case?
Written by BubikolRamios
3 years ago
326 posts since Thu, 14 Jan 10
Tell me that I have no privs and which is that I need. I mean I do get that kind of info from time to time from different apps. mybe even form HSQL, can tell out from head now.

As it is now, I could panic that all my triggers are gone.
Written by ansgar
3 years ago
4801 posts since Fri, 07 Apr 06
Think you need the SUPER privilege on 5.1 servers and below, and on newer servers you need the TRIGGER priv. But I can be wrong.
 

Please login to leave a reply, or register at first.