allow nested triggers

Summary information

Default value

1 (on)

Valid values

0 (off), 1 (on)

Status

Static

Display level

Intermediate

Required role

System Administrator

allow nested triggers controls the use of nested triggers. When the value is set to 1, data modifications made by triggers can fire other triggers. Set allow nested triggers to 0 to disable nested triggers. A set option, self_recursion, controls whether the modifications made by a trigger can cause that trigger to fire again.