Subject | Updating table without triggering trigger |
---|---|
Author | Daniel Albuschat |
Post date | 2010-04-14T14:23:34Z |
Hello,
I have a table with a "before update" trigger. In some special cases,
I want to update this table without triggering that trigger.
My guess is that "alter trigger <trigger> inactive" will make it
inactive to all other transactions, too, right?
Or is it possible to make it inactive, update the table and make it
active again, without interfering with other transactions?
Regards,
Daniel Albuschat
I have a table with a "before update" trigger. In some special cases,
I want to update this table without triggering that trigger.
My guess is that "alter trigger <trigger> inactive" will make it
inactive to all other transactions, too, right?
Or is it possible to make it inactive, update the table and make it
active again, without interfering with other transactions?
Regards,
Daniel Albuschat