Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7579

Create a method to disable triggers

        Details

        • Type: Task
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Fix Version/s: None
        • Component/s: Triggers
        • Labels:
          None

          Description

          Currently, there is no easy way to temporarily disable triggers. This is important for some users. It might be a good idea to have some (maybe not all?) of the following:

          Temporarily disable all triggers on a particular table:

          ALTER TABLE foo DISABLE TRIGGERS;

          Re-enable the triggers:

          ALTER TABLE foo ENABLE TRIGGERS;

          Disable a particular trigger on a table:

          ALTER TABLE foo DISABLE TRIGGER bar;

          Re-enable it:

          ALTER TABLE foo ENABLE TRIGGER bar;

          Disable triggers for a particular user:

          ALTER TABLE foo DISABLE TRIGGERS FOR CURRENT_USER();

          Disable all triggers for current session (maybe requires superuser privileges?):

          SET disable_triggers = ON;

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    GeoffMontee Geoff Montee
                  • Votes:
                    1 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated: