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