1Parsed test spec with 2 sessions 2 3starting permutation: s1a s2a s2b s1b s2c 4step s1a: SELECT * FROM foo FOR SHARE NOWAIT; 5id|data 6--+---- 7 1|x 8(1 row) 9 10step s2a: SELECT * FROM foo FOR SHARE NOWAIT; 11id|data 12--+---- 13 1|x 14(1 row) 15 16step s2b: SELECT * FROM foo FOR UPDATE NOWAIT; 17ERROR: could not obtain lock on row in relation "foo" 18step s1b: COMMIT; 19step s2c: COMMIT; 20 21starting permutation: s2a s1a s2b s1b s2c 22step s2a: SELECT * FROM foo FOR SHARE NOWAIT; 23id|data 24--+---- 25 1|x 26(1 row) 27 28step s1a: SELECT * FROM foo FOR SHARE NOWAIT; 29id|data 30--+---- 31 1|x 32(1 row) 33 34step s2b: SELECT * FROM foo FOR UPDATE NOWAIT; 35ERROR: could not obtain lock on row in relation "foo" 36step s1b: COMMIT; 37step s2c: COMMIT; 38 39starting permutation: s2a s2b s1a s1b s2c 40step s2a: SELECT * FROM foo FOR SHARE NOWAIT; 41id|data 42--+---- 43 1|x 44(1 row) 45 46step s2b: SELECT * FROM foo FOR UPDATE NOWAIT; 47id|data 48--+---- 49 1|x 50(1 row) 51 52step s1a: SELECT * FROM foo FOR SHARE NOWAIT; 53ERROR: could not obtain lock on row in relation "foo" 54step s1b: COMMIT; 55step s2c: COMMIT; 56