recursiveTriggers

Queries or sets the recursive_triggers flag.

When enabled (true), triggers are allowed to fire other triggers. For example, if an INSERT on table A causes a trigger to fire that performs an INSERT on table B, and table B has its own INSERT trigger, the second trigger will only fire if recursive triggers are enabled.

When disabled (false, the default), a trigger is prohibited from firing another trigger. This prevents infinite loops where a trigger action could cause the same trigger to be fired again indirectly.

Enabling this should be done with caution, as it can lead to complex and hard-to-debug behavior, including unintended infinite recursion.

See also