Search Postgresql Archives

Re: After Trigger

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thursday 21 September 2006 12:44 pm, Bob Pawley <rjpawley@xxxxxxx> 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@xxxxxxxx
www.turbocorp.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux