Re: [GENERAL] Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred trigger fire events done in one of the system catalogues?

[Tom Lane]

Frank van Vugt <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend