Re: Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred trigger fire events done in one of the system catalogues? - Mailing list pgsql-general
From
Tom Lane
Subject
Re: Does a 'stable' deferred trigger execution order exist? Is housekeeping for deferred trigger fire events done in one of the system catalogues?
Frank van Vugt <ftm.van.vugt@foxi.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
