Re: What Is The Firing Order?

> > Should we get a system where the user can control the firing, perhaps
> > using oid order?
>
> I don't think oid order would help, because what happens if you've say got
> a trigger and then want to add another before it?  I'd guess the most
> general way would be to give triggers some kind of numeric ordering not
> associated with anything else, but then you need ways to set it on create
> trigger and probably an alter trigger way to change it. :(  I'd guess that
> there'd be a default value if you didn't set it, and that triggers of the
> same value would run in indeterminate order like before.

Yes, the problem with alphabetical order is that mere creation of a
trigger would change the firing order.  I was thinking oid order so
there is some stability to the system for people who don't care about
the order, and a way to control it for people who need to (create
triggers in desired 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