I am creating a system where I have a trigger on three different tables.
There is a particular Boolean field in each of these tables that when it is
set in table it should be set the same in the other two.
So I figured I could put a trigger on each table that when the Boolean field
was updated it would go and update the other 2.
However, I am concerned about cascading trigger calls.
Does anyone know if it is possible to run an update statement on a table and
for only that statement disable the trigger on the table?