Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl> writes:
> If during a transaction a number of deferred triggers are fired, what will be
> their execution order upon the commit?
Should be alphabetical within each triggering event, IIRC.
> Also, are the fire-events of deferred triggers kept in a system catalogue
> somewhere,
No. They're in a list in memory.
regards, tom lane