| Subject | RE: [IBDI] Order of triggers with same position number? |
|---|---|
| Author | David Schnepper |
| Post date | 2000-06-15T18:11:07Z |
I
recall running across this a few years ago -- and changing the firing order
to
POSITION, TRIGGER_NAME
so
there was always a defined order. However, we did NOT document it.
If there is
an
"ordering" relationship needed position should be used.
Dave
-----Original Message-----At 02:12 AM 6/15/00 -0400, Claudio Valderrama C. wrote:
From: Ann Harrison [mailto:harrison@...]
Sent: Thursday, June 15, 2000 7:48 AM
To: IBDI@egroups.com; IBDI@egroups.com
Subject: Re: [IBDI] Order of triggers with same position number?
>LangRef in page 81 says at the end:
>«Triggers for a table need not be consecutive; triggers on the same action
>with the same position number will fire in random order.»
>
>Is this ok still? Why did I have the idea that there was some order among
>triggers that share the same POSITION... or do I need vacations?
Whether or not you need a vacation, I believe that if you have
three triggers defined as "before update position 8" they will
fire after all "before update" triggers with a position less
than 8, which includes those with no defined position, before all
those with a position higher than 8, and in an arbitrary order
among themselves.
Ann
Community email addresses:
Post message: IBDI@onelist.com
Subscribe: IBDI-subscribe@onelist.com
Unsubscribe: IBDI-unsubscribe@onelist.com
List owner: IBDI-owner@onelist.com
Shortcut URL to this page:
http://www.onelist.com/community/IBDI