His proposal is "restarting the transaction....a little tricky...there are simple ways to solve this problem that are out of scope for this post."

This is the hard part.