Nevermind my previous question, I just realized that I'm using INSTEAD OF when you were using FOR UPDATE.

I corrected the trigger definition, tested it and it seems to work.

Any reasons NOT to have such a trigger on production?