Subject How to avoid Triggers' infinite loop?
Author Anderson Miranda
Hi there,

I have a simple scheme like this:

TABLE_A => After update, update TABLE_B
TABLE_B => After update, update TABLE_A

Problem is, if I do such thing using triggers on both tables, I would
ran into an infinite loop between triggers.

My question is: How could I avoid the infinite loop and still achieve
the above mentioned scheme?

Regards,
Anderson