Re: What Is The Firing Order?

> > That seems fairly arbitrary; someone else might wish the opposite,
> > depending on the details of what they want to do.
>
> We should probably check first whether the SQL standard has anything to
> say about the relative ordering of foreign key cascade actions versus
> triggers.  (I would tend to think that triggers come after FK actions.
> However, things might get tricky when cascade actions fire triggers of
> their own.)
>
> The order of execution of "pure" triggers meanwhile is defined thus:
>
>          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. If one or more triggers have the
>          same timestamp value, then their relative order of execution is
>          implementation-defined.  [4.35]
>
> This is probably what happens in practice anyway, so it might make sense
> to follow this rule.

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

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026