Hello:
Is there a builtin mechanism for detecting trigger recursion or more
specifically
one trigger , causing another tables trigger to fire.
Example:
Table A is updated
Table A's update trigger executes
{
Updates the B table - (maintaining special RI etc.)
Table B's update trigger executes
{
<does some stuff>
<need to know if I was triggered from within another trigger> ?????
( Is there a function that does this? )
<does some more stuff>
}
}
begin:vcard
n:Roberts;Vincent
x-mozilla-html:FALSE
org:Fox Chase Cancer Center;Web Communications & Technology
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:Web Programmer
x-mozilla-cpt:;-11520
fn:Vincent Roberts
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
