Trigger behavior- general question
Posted on 2006-06-16
I have a trigger on a table, that is called when a column is updated. Within the trigger, I have some code that does an update to the same table/column.
It appears that the trigger only fires the first time, and does not get invoked when an update is ran from within the trigger.
I'm guessing that this is desired and expected behavior, because you would not want a trigger to get in an endless loop. Could someone please confirm this? Is there a way that you could over-ride the behavior if you needed to? (not to put it into an endless loop, but just for the trigger to fire because of the second update).
Any help greatly appreciated.