However, in the webinar, I wanted to remind everyone about the differences between LOCK IN SHARE MODE and FOR UPDATE . To do so, I added the former to my “session 2” test for the webinar. Once I did, it ignores the lock set in “session 1.” I can update a row and commit: