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