Re: How to avoid Trigger ping/pong / infinite loop

[David Wheeler <hippysoyboy@xxxxxxxxx>]

Are there techniques for situations like this?

Just have two triggers, one for each column, and ensure that if your trigger doesn’t change the value then it doesn’t do an update on the other column. Each time you do update both triggers will run but only one will make a change, so that will break the cycle

For insert case ensure the triggers do nothing if their source col is null