The insert trigger will update the same table and thereby triggers the update trigger. Which in return executes the whole update trigger. (See code below)
We have multiple places where this trigger nesting causes errors or wrong results.
If we could add a DEFAULT constraint to the insert columns the code of the insert trigger won't be necessary anymore.
Best answer by Jasper
View original