1Parsed test spec with 3 sessions
2
3starting permutation: s1b s1s s2d s3i1 s1c
4step s1b: BEGIN;
5step s1s: SELECT * FROM d_lp_fk;
6a
7-
81
92
10(2 rows)
11
12step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; <waiting ...>
13step s3i1: INSERT INTO d_lp_fk_r VALUES (1);
14ERROR:  insert or update on table "d_lp_fk_r" violates foreign key constraint "d_lp_fk_r_a_fkey"
15step s1c: COMMIT;
16step s2d: <... completed>
17
18starting permutation: s1b s1s s2d s3i2 s3i2 s1c
19step s1b: BEGIN;
20step s1s: SELECT * FROM d_lp_fk;
21a
22-
231
242
25(2 rows)
26
27step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; <waiting ...>
28step s3i2: INSERT INTO d_lp_fk_r VALUES (2);
29step s3i2: INSERT INTO d_lp_fk_r VALUES (2);
30step s1c: COMMIT;
31step s2d: <... completed>
32
33starting permutation: s1b s1s s3i1 s2d s1c
34step s1b: BEGIN;
35step s1s: SELECT * FROM d_lp_fk;
36a
37-
381
392
40(2 rows)
41
42step s3i1: INSERT INTO d_lp_fk_r VALUES (1);
43step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY;
44ERROR:  removing partition "d_lp_fk_1" violates foreign key constraint "d_lp_fk_r_a_fkey1"
45step s1c: COMMIT;
46
47starting permutation: s1b s1s s3i2 s2d s1c
48step s1b: BEGIN;
49step s1s: SELECT * FROM d_lp_fk;
50a
51-
521
532
54(2 rows)
55
56step s3i2: INSERT INTO d_lp_fk_r VALUES (2);
57step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; <waiting ...>
58step s1c: COMMIT;
59step s2d: <... completed>
60
61starting permutation: s1b s1s s3b s2d s3i1 s1c s3c
62step s1b: BEGIN;
63step s1s: SELECT * FROM d_lp_fk;
64a
65-
661
672
68(2 rows)
69
70step s3b: BEGIN;
71step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; <waiting ...>
72step s3i1: INSERT INTO d_lp_fk_r VALUES (1);
73ERROR:  insert or update on table "d_lp_fk_r" violates foreign key constraint "d_lp_fk_r_a_fkey"
74step s1c: COMMIT;
75step s2d: <... completed>
76step s3c: COMMIT;
77