There are some things you have to bear in mind when writing transitional constraints. These are described in the following paragraphs.
See Also:
OLD() Value During Constraint Processing
Current Row Counting
Unwanted New Value Substitution
