diff options
Diffstat (limited to 'src/test/regress/expected/partition_split.out')
-rw-r--r-- | src/test/regress/expected/partition_split.out | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/src/test/regress/expected/partition_split.out b/src/test/regress/expected/partition_split.out index 675a1453c34..26a0d099696 100644 --- a/src/test/regress/expected/partition_split.out +++ b/src/test/regress/expected/partition_split.out @@ -1414,4 +1414,17 @@ SELECT * FROM sales_others; DROP TABLE sales_range; -- +-- Try to SPLIT partition of another table. +-- +CREATE TABLE t1(i int, t text) PARTITION BY LIST (t); +CREATE TABLE t1pa PARTITION OF t1 FOR VALUES IN ('A'); +CREATE TABLE t2 (i int, t text) PARTITION BY RANGE (t); +-- ERROR: relation "t1pa" is not a partition of relation "t2" +ALTER TABLE t2 SPLIT PARTITION t1pa INTO + (PARTITION t2a FOR VALUES FROM ('A') TO ('B'), + PARTITION t2b FOR VALUES FROM ('B') TO ('C')); +ERROR: relation "t1pa" is not a partition of relation "t2" +DROP TABLE t2; +DROP TABLE t1; +-- DROP SCHEMA partition_split_schema; |