Heidi can't manage triggers?
Brought to you by:
ansgarbecker
Originally created by: Vincent....@gmail.com
It would be great if Heidi table's properties could manage trigger:
- show tables witch has triggers (an icon or special style like underline..)
- add
- edit
- delete triggers
(Anyway Heidi is really an excellent tool, sorry for my english)
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: rosenfie...@gmail.com
Thanks.
Status: Accepted
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: arjoc....@gmail.com
How is the trigger management going? This would be really useful :-)
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
Sorry, not yet done something on that. Agree that it's useful!
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: afi.w...@gmail.com
And the list of triggers in one place also for each table separately!
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
Issue 1171 has been merged into this issue.
Related
Tickets:
#1171View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: rox...@gmail.com
Can add a flag in "table editor" in the select table is active some trigger?
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: eli.rash...@gmail.com
it could be very nice,
you can find all triggers in information_schema.triggers
select * from information_schema.triggers
where TRIGGER_SCHEMA = "<ypur_schema>"
but it could be better it it would be integrate into the "table" tab
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: sirkorro
I agree.
It would be nice to habe triggers (all related objects?) in 'table' tab.
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
Currently working on a trigger editor. See attached screenshot. Feedback appreciated.
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
Needless to say that typing "NEW." or "OLD." triggers the auto completer to show up
the columns of the selected table.
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: kAlvaro
I'm not sure I like default names ("UntitledTrigger"), they tend to mask the fact
that you haven't filled a field yet. Other than that, it looks pretty good IMHO.
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
Yes, "UntitledTrigger" is bad. What about "Enter trigger name", would be more clear
that the user needs to do something here, would it?
And, I think I'll convert these radio button boxes to comboboxes, fit better into the
layout.
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
This issue was closed by revision [r2852].
Mergedinto: -
Status: Fixed
Related
Commit: [r2852]
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: eli.rash...@gmail.com
thanks ansgar as usual you are the best:)