Menu

#806 Heidi can't manage triggers?

Fixed
nobody
None
Default
Enhancement
2009-12-12
2008-10-16
Anonymous
No

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)

Related

Tickets: #1171
Tickets: #334

Discussion

  • Anonymous

    Anonymous - 2008-10-17

    Originally posted by: rosenfie...@gmail.com

    Thanks.

    Status: Accepted

     
  • Anonymous

    Anonymous - 2009-03-24

    Originally posted by: arjoc....@gmail.com

    How is the trigger management going? This would be really useful :-)

     
  • Anonymous

    Anonymous - 2009-03-24

    Originally posted by: a...@anse.de

    Sorry, not yet done something on that. Agree that it's useful!

     
  • Anonymous

    Anonymous - 2009-04-02

    Originally posted by: afi.w...@gmail.com

    And the list of triggers in one place also for each table separately!

     
  • Anonymous

    Anonymous - 2009-09-26

    Originally posted by: rox...@gmail.com

    Can add a flag in "table editor" in the select table is active some trigger?

     
  • Anonymous

    Anonymous - 2009-11-05

    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

     
  • Anonymous

    Anonymous - 2009-11-11

    Originally posted by: sirkorro

    I agree.
    It would be nice to habe triggers (all related objects?) in 'table' tab.

     
  • Anonymous

    Anonymous - 2009-12-10

    Originally posted by: a...@anse.de

    Currently working on a trigger editor. See attached screenshot. Feedback appreciated.

     
  • Anonymous

    Anonymous - 2009-12-10

    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.

     
  • Anonymous

    Anonymous - 2009-12-11

    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.

     
  • Anonymous

    Anonymous - 2009-12-11

    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.

     
  • Anonymous

    Anonymous - 2009-12-11

    Originally posted by: a...@anse.de

    This issue was closed by revision [r2852].

    Mergedinto: -
    Status: Fixed

     

    Related

    Commit: [r2852]

  • Anonymous

    Anonymous - 2009-12-12

    Originally posted by: eli.rash...@gmail.com

    thanks ansgar as usual you are the best:)

     
Auth0 Logo