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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026