Comment by tmulcahy

> The lock ordering rules had become too complicated and this was getting us too many transaction restarts, so I stole the standard technique from databases

What is the standard technique from databases?