• if you define constraint then you don't have situation for update,

    because there will be no rows with impaired restriction, unless you disable constraint.