1Parsed test spec with 2 sessions
2
3starting permutation: wxry1 c1 r2 wyrx2 c2
4step wxry1: INSERT INTO child (parent_id) VALUES (0);
5step c1: COMMIT;
6step r2: SELECT TRUE;
7bool
8----
9t
10(1 row)
11
12step wyrx2: DELETE FROM parent WHERE parent_id = 0;
13ERROR:  child row exists
14step c2: COMMIT;
15
16starting permutation: wxry1 r2 c1 wyrx2 c2
17step wxry1: INSERT INTO child (parent_id) VALUES (0);
18step r2: SELECT TRUE;
19bool
20----
21t
22(1 row)
23
24step c1: COMMIT;
25step wyrx2: DELETE FROM parent WHERE parent_id = 0;
26ERROR:  could not serialize access due to read/write dependencies among transactions
27step c2: COMMIT;
28
29starting permutation: wxry1 r2 wyrx2 c1 c2
30step wxry1: INSERT INTO child (parent_id) VALUES (0);
31step r2: SELECT TRUE;
32bool
33----
34t
35(1 row)
36
37step wyrx2: DELETE FROM parent WHERE parent_id = 0;
38step c1: COMMIT;
39step c2: COMMIT;
40ERROR:  could not serialize access due to read/write dependencies among transactions
41
42starting permutation: wxry1 r2 wyrx2 c2 c1
43step wxry1: INSERT INTO child (parent_id) VALUES (0);
44step r2: SELECT TRUE;
45bool
46----
47t
48(1 row)
49
50step wyrx2: DELETE FROM parent WHERE parent_id = 0;
51step c2: COMMIT;
52step c1: COMMIT;
53ERROR:  could not serialize access due to read/write dependencies among transactions
54
55starting permutation: r2 wxry1 c1 wyrx2 c2
56step r2: SELECT TRUE;
57bool
58----
59t
60(1 row)
61
62step wxry1: INSERT INTO child (parent_id) VALUES (0);
63step c1: COMMIT;
64step wyrx2: DELETE FROM parent WHERE parent_id = 0;
65ERROR:  could not serialize access due to read/write dependencies among transactions
66step c2: COMMIT;
67
68starting permutation: r2 wxry1 wyrx2 c1 c2
69step r2: SELECT TRUE;
70bool
71----
72t
73(1 row)
74
75step wxry1: INSERT INTO child (parent_id) VALUES (0);
76step wyrx2: DELETE FROM parent WHERE parent_id = 0;
77step c1: COMMIT;
78step c2: COMMIT;
79ERROR:  could not serialize access due to read/write dependencies among transactions
80
81starting permutation: r2 wxry1 wyrx2 c2 c1
82step r2: SELECT TRUE;
83bool
84----
85t
86(1 row)
87
88step wxry1: INSERT INTO child (parent_id) VALUES (0);
89step wyrx2: DELETE FROM parent WHERE parent_id = 0;
90step c2: COMMIT;
91step c1: COMMIT;
92ERROR:  could not serialize access due to read/write dependencies among transactions
93
94starting permutation: r2 wyrx2 wxry1 c1 c2
95step r2: SELECT TRUE;
96bool
97----
98t
99(1 row)
100
101step wyrx2: DELETE FROM parent WHERE parent_id = 0;
102step wxry1: INSERT INTO child (parent_id) VALUES (0);
103step c1: COMMIT;
104step c2: COMMIT;
105ERROR:  could not serialize access due to read/write dependencies among transactions
106
107starting permutation: r2 wyrx2 wxry1 c2 c1
108step r2: SELECT TRUE;
109bool
110----
111t
112(1 row)
113
114step wyrx2: DELETE FROM parent WHERE parent_id = 0;
115step wxry1: INSERT INTO child (parent_id) VALUES (0);
116step c2: COMMIT;
117step c1: COMMIT;
118ERROR:  could not serialize access due to read/write dependencies among transactions
119
120starting permutation: r2 wyrx2 c2 wxry1 c1
121step r2: SELECT TRUE;
122bool
123----
124t
125(1 row)
126
127step wyrx2: DELETE FROM parent WHERE parent_id = 0;
128step c2: COMMIT;
129step wxry1: INSERT INTO child (parent_id) VALUES (0);
130ERROR:  parent row missing
131step c1: COMMIT;
132