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.