1Parsed test spec with 2 sessions
2
3starting permutation: s1b s1a s2b s2i s1c s2c s2s
4step s1b: begin;
5step s1a: alter table tpart attach partition tpart_2 for values from (100) to (200);
6step s2b: begin;
7step s2i: insert into tpart values (110,'xxx'), (120, 'yyy'), (150, 'zzz'); <waiting ...>
8step s1c: commit;
9step s2i: <... completed>
10ERROR:  new row for relation "tpart_default" violates partition constraint
11step s2c: commit;
12step s2s: select tableoid::regclass, * from tpart;
13tableoid|  i|j
14--------+---+---
15tpart_2 |110|xxx
16tpart_2 |120|yyy
17tpart_2 |150|zzz
18(3 rows)
19
20
21starting permutation: s1b s1a s2b s2i2 s1c s2c s2s
22step s1b: begin;
23step s1a: alter table tpart attach partition tpart_2 for values from (100) to (200);
24step s2b: begin;
25step s2i2: insert into tpart_default (i, j) values (110, 'xxx'), (120, 'yyy'), (150, 'zzz'); <waiting ...>
26step s1c: commit;
27step s2i2: <... completed>
28ERROR:  new row for relation "tpart_default" violates partition constraint
29step s2c: commit;
30step s2s: select tableoid::regclass, * from tpart;
31tableoid|  i|j
32--------+---+---
33tpart_2 |110|xxx
34tpart_2 |120|yyy
35tpart_2 |150|zzz
36(3 rows)
37
38
39starting permutation: s1b s2b s2i s1a s2c s1c s2s
40step s1b: begin;
41step s2b: begin;
42step s2i: insert into tpart values (110,'xxx'), (120, 'yyy'), (150, 'zzz');
43step s1a: alter table tpart attach partition tpart_2 for values from (100) to (200); <waiting ...>
44step s2c: commit;
45step s1a: <... completed>
46ERROR:  updated partition constraint for default partition "tpart_default_default" would be violated by some row
47step s1c: commit;
48step s2s: select tableoid::regclass, * from tpart;
49tableoid             |  i|j
50---------------------+---+---
51tpart_default_default|110|xxx
52tpart_default_default|120|yyy
53tpart_default_default|150|zzz
54(3 rows)
55
56