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