Re: What Is The Firing Order?

Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> The order of execution of a set of triggers is ascending by value
>> of their timestamp of creation in their descriptors, such that the
>> oldest trigger executes first.

> Yep, that would be a pretty strong vote for OID order.

Au contraire: OID wraparound would cause us to violate the spec.
If we want to follow the spec here, then I think we'd need to add
a creation-timestamp column to pg_trigger, and sort on that.

            regards, tom lane