...
- When the default global handlers are updated, this will only apply to newly prepared tables. Tables that have already been prepared (or replicated) will still use the previous defined default global handler.
- We recommend to not set nontrivial default conflict handlers for the ERROR handlers. The reason is that if you get 0/many rows affected, the DATA handlers like OVERWRITE, NEWER, OLDER are a good way how to handle the conflict. If they fail, they fall through to the ERROR handler. If the ERROR handler is set to OVERWRITE, NEWER, OLDER, then the ERROR handler could loop forever.
- The default handlers are also used if the conflict is "globa", i.e. it's not for a particular table. The most prominent example is a conflict for a commit (e.g. a failed deferred constraint).