SQLCreateTrigger.TimingSpecifier.deferrable

The trigger’s execution may be deferred until the end of the active transaction by SET CONSTRAINTS ... DEFERRED, but runs immediately by default.

case deferrable