Re: What Is The Firing Order?

On Fri, 7 Sep 2001, Tom Lane wrote:

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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.

If you are going to create a separate column for sorting, why not just
use a numeric (int8?) value, so one can change that as sees fit? Maybe
associated with a database-wide sequence...

--
Alvaro Herrera (<alvherre[(at)]atentus(dot)com>)