On Fri, 7 Sep 2001, Tom Lane wrote:
> 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.
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[@]atentus.com>)