Re: What Is The Firing Order? - Mailing list pgsql-general

From Tom Lane
Subject Re: What Is The Firing Order?
Date
Msg-id 4321.999894001@sss.pgh.pa.us
Whole thread Raw
In response to Re: What Is The Firing Order?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: What Is The Firing Order?
List pgsql-general
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

pgsql-general by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: moving char() to varchar()
Next
From: Tom Lane
Date:
Subject: Re: moving char() to varchar()