diff options
Diffstat (limited to 'src/test/isolation/expected/detach-partition-concurrently-2.out')
-rw-r--r-- | src/test/isolation/expected/detach-partition-concurrently-2.out | 40 |
1 files changed, 25 insertions, 15 deletions
diff --git a/src/test/isolation/expected/detach-partition-concurrently-2.out b/src/test/isolation/expected/detach-partition-concurrently-2.out index 85be707b404..6f025d81f5e 100644 --- a/src/test/isolation/expected/detach-partition-concurrently-2.out +++ b/src/test/isolation/expected/detach-partition-concurrently-2.out @@ -3,10 +3,12 @@ Parsed test spec with 3 sessions starting permutation: s1b s1s s2d s3i1 s1c step s1b: BEGIN; step s1s: SELECT * FROM d_lp_fk; -a +a +- +1 +2 +(2 rows) -1 -2 step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; <waiting ...> step s3i1: INSERT INTO d_lp_fk_r VALUES (1); ERROR: insert or update on table "d_lp_fk_r" violates foreign key constraint "d_lp_fk_r_a_fkey" @@ -16,10 +18,12 @@ step s2d: <... completed> starting permutation: s1b s1s s2d s3i2 s3i2 s1c step s1b: BEGIN; step s1s: SELECT * FROM d_lp_fk; -a +a +- +1 +2 +(2 rows) -1 -2 step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; <waiting ...> step s3i2: INSERT INTO d_lp_fk_r VALUES (2); step s3i2: INSERT INTO d_lp_fk_r VALUES (2); @@ -29,10 +33,12 @@ step s2d: <... completed> starting permutation: s1b s1s s3i1 s2d s1c step s1b: BEGIN; step s1s: SELECT * FROM d_lp_fk; -a +a +- +1 +2 +(2 rows) -1 -2 step s3i1: INSERT INTO d_lp_fk_r VALUES (1); step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; ERROR: removing partition "d_lp_fk_1" violates foreign key constraint "d_lp_fk_r_a_fkey1" @@ -41,10 +47,12 @@ step s1c: COMMIT; starting permutation: s1b s1s s3i2 s2d s1c step s1b: BEGIN; step s1s: SELECT * FROM d_lp_fk; -a +a +- +1 +2 +(2 rows) -1 -2 step s3i2: INSERT INTO d_lp_fk_r VALUES (2); step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; <waiting ...> step s1c: COMMIT; @@ -53,10 +61,12 @@ step s2d: <... completed> starting permutation: s1b s1s s3b s2d s3i1 s1c s3c step s1b: BEGIN; step s1s: SELECT * FROM d_lp_fk; -a +a +- +1 +2 +(2 rows) -1 -2 step s3b: BEGIN; step s2d: ALTER TABLE d_lp_fk DETACH PARTITION d_lp_fk_1 CONCURRENTLY; <waiting ...> step s3i1: INSERT INTO d_lp_fk_r VALUES (1); |