Subject | How to avoid Triggers' infinite loop? |
---|---|
Author | Anderson Miranda |
Post date | 2005-08-30T15:11:13Z |
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
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