> So do we put recursion limits on UPDATE and INSERT triggers > only and let DELETE triggers run as long as they like? > That works as far as I know, but it seems kind of arbitrary. > > Surely somebody else has been down this road before me and > can offer a little guidance?
Why don't give this burden to the user? In every language it is possible to create an infinite loop and the programmer have to fix it. Regards, Lothar