How to solve trigger side effects

From: <thalion77_at_graffiti.net>
Date: Fri, 06 Jul 2007 04:53:59 -0700
Message-ID: <1183722839.485902.59900@57g2000hsv.googlegroups.com>

Hello there,

I've got 2 triggers. Each trigger belongs to a certain table.

Now I've got following problem. One trigger does something which leads to execution of the other trigger. The reason is, that the one trigger changes data in that table having the other trigger. Now I want to deactivate the second trigger, if it was triggered by the first trigger. Is there a way to find out, who is the causer of a trigger.

Or is there a way to find out, whether a certain table is just now updated? So I can deactivate the second trigger, if just now data are updated in the first table.

Does anyone have an advice for me?

Thanks in advance,
Norbert Received on Fri Jul 06 2007 - 06:53:59 CDT