SQLCreateTrigger.TimingSpecifier.deferredByDefault

The trigger’s execution is deferred until the end of the active transaction unless changed by SET CONSTRAINTS ... IMMEDIATE.

case deferredByDefault