setup { DROP TABLE IF EXISTS foo; CREATE TABLE foo ( key int PRIMARY KEY, value int ); INSERT INTO foo VALUES (1, 1); } teardown { DROP TABLE foo; } session "s1" setup { SET log_lock_waits = on; SET client_min_messages = LOG; } step "s1-update" { BEGIN; UPDATE foo SET value = 2; } step "s1-commit" { SELECT pg_sleep(1.5); COMMIT; } session "s2" setup { SET log_lock_waits = on; SET client_min_messages = LOG; BEGIN; } step "s2-update" { UPDATE foo SET value = 3; } teardown { ROLLBACK; } permutation "s1-update" "s2-update" "s1-commit"