diff options
Diffstat (limited to 'src/test/isolation/expected/drop-index-concurrently-2.out')
| -rw-r--r-- | src/test/isolation/expected/drop-index-concurrently-2.out | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/src/test/isolation/expected/drop-index-concurrently-2.out b/src/test/isolation/expected/drop-index-concurrently-2.out new file mode 100644 index 0000000000..4802777623 --- /dev/null +++ b/src/test/isolation/expected/drop-index-concurrently-2.out @@ -0,0 +1,24 @@ +Parsed test spec with 3 sessions + +starting permutation: explain drop cancel rollback droptab selecti dropi +step explain: EXPLAIN (COSTS OFF) SELECT * FROM test_dc WHERE data=34343; +QUERY PLAN + +Bitmap Heap Scan on test_dc + Recheck Cond: (data = 34343) + -> Bitmap Index Scan on test_dc_data + Index Cond: (data = 34343) +step drop: DROP INDEX CONCURRENTLY test_dc_data; <waiting ...> +step cancel: SELECT pg_cancel_backend(pid) FROM pg_stat_activity WHERE query = 'DROP INDEX CONCURRENTLY test_dc_data;'; +pg_cancel_backend + +t +step drop: <... completed> +error in steps cancel drop: ERROR: canceling statement due to user request +step rollback: ROLLBACK; +step droptab: DROP TABLE test_dc; +step selecti: SELECT indexrelid::regclass, indisvalid, indisready FROM pg_index WHERE indexrelid = 'test_dc_data'::regclass; +indexrelid indisvalid indisready + +test_dc_data f f +step dropi: DROP INDEX test_dc_data; |
