On Thursday 21 September 2006 12:44 pm, Bob Pawley <rjpawley@shaw.ca> thus
communicated:
--> I am seeking wording for a procedure that will initiate a trigger only
after another trigger has completed its function. In this case I want to
drop a table that is created and used by the first trigger. -->
--> Could someone point me to documentation?
-->
--> Bob Pawley
According to the 7.4.6 docs:
"If more than one trigger is defined for the same event on the same relation,
the triggers will be fired in alphabetical order by trigger name. In the case
of before triggers, the possibly-modified row returned by each trigger
becomes the input to the next trigger. If any before trigger returns a NULL
pointer, the operation is abandoned and subsequent triggers are not fired. "
So, name the last trigger you want to fire such that it falls aphabetically
behind the rest.
--
Terry Tucker
Turbo's IT Manager
Turbo, division of Ozburn-Hessey Logistics
2251 Jesse Jewell Pkwy NE
Gainesville, GA 30501
Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 363-4719
terry@esc1.com
www.turbocorp.com