couldn't you also just use an after update trigger? or is it not commited in the original table yet?

in any case exception handling is probablly the most robust way to go.