Comment by mapleoin

I don't see the update in the post. If you pass the version in an UPDATE statement it will get overridden by the trigger.

NEW.version := OLD.version + 1;