mutation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: mutation

  1. #1
    Join Date
    Nov 2000
    Posts
    35

    Arrow

    what is a mutation in triggers ?

  2. #2
    Join Date
    Apr 2001
    Posts
    14
    If you try to change or select the data of the same table on which the trigger is firing , then the the table is said to be mutating. this is because you are trying to alter the data in the table which is undergoing a change.
    Anil
    anil_tj@yahoo.com

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    A related issue is that you cannot access the key columns in a table with a defined primary/foreign key relationship to the mutating table. This is called a constraining table.

    Thus if your trigger in table "child" has a FK of "ID", you cannot query the related table "parent" by "ID" to update some field in that table, since the "ID" is the related field.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width