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

Support for INSTEAD OF triggers

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Are there any plans to implement INSTEAD OF triggers for views?

      An INSTED OF trigger is code that is executed instead of an INSERT, DELETE or UPDATE statement.
      This works for both tables and views.

      Syntax:

      CREATE TRIGGER [schema_name.] trigger_name
      ON

      {table_name | view_name }

      INSTEAD OF

      {[INSERT] [,] [UPDATE] [,] [DELETE] }

      AS

      {sql_statements}

      You can find some documentation about this at:
      https://www.sqlservertutorial.net/sql-server-triggers/sql-server-instead-of-trigger/
      https://www.oracletutorial.com/plsql-tutorial/oracle-instead-of-triggers/

      Attachments

        Activity

          People

            Unassigned Unassigned
            balta Tadas Balaišis
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.