create table bookings ( seat int, reserved boolean default false ); insert into bookings ( seat ) values ( 42 ); begin transaction; select * from bookings where seat=42 for share; ! psql -ec ‘begin transaction’ -c ‘select * from bookings where seat=42 for share’ -c ‘select pg_sleep(5)’ -c ‘update bookings set reserved=true where seat=42’ -c ‘commit’ | sed ‘s/^/ (other session) /’ & sleep 1 update bookings set reserved=true where seat=42; commit; ~