summaryrefslogtreecommitdiff
path: root/src/test/regress/expected/create_table.out
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2017-04-28 13:52:17 -0400
committerRobert Haas <rhaas@postgresql.org>2017-04-28 13:52:17 -0400
commit504c2205abc7de67386f9c95630f38ee15626f07 (patch)
treeaa9c17b2e349678b1eba48532b6588d6a9236473 /src/test/regress/expected/create_table.out
parente3cf708016ca6045dc1cd5a0768cfecf17caf3d1 (diff)
downloadpostgresql-504c2205abc7de67386f9c95630f38ee15626f07.tar.gz
Fix crash when partitioned column specified twice.
Amit Langote, reviewed by Beena Emerson Discussion: http://postgr.es/m/6ed23d3d-c09d-4cbc-3628-0a8a32f750f4@lab.ntt.co.jp
Diffstat (limited to 'src/test/regress/expected/create_table.out')
-rw-r--r--src/test/regress/expected/create_table.out8
1 files changed, 8 insertions, 0 deletions
diff --git a/src/test/regress/expected/create_table.out b/src/test/regress/expected/create_table.out
index 3f94250df2..dda0d7ee5d 100644
--- a/src/test/regress/expected/create_table.out
+++ b/src/test/regress/expected/create_table.out
@@ -609,6 +609,14 @@ SELECT attname, attislocal, attinhcount FROM pg_attribute
(2 rows)
-- able to specify column default, column constraint, and table constraint
+-- first check the "column specified more than once" error
+CREATE TABLE part_b PARTITION OF parted (
+ b NOT NULL,
+ b DEFAULT 1,
+ b CHECK (b >= 0),
+ CONSTRAINT check_a CHECK (length(a) > 0)
+) FOR VALUES IN ('b');
+ERROR: column "b" specified more than once
CREATE TABLE part_b PARTITION OF parted (
b NOT NULL DEFAULT 1 CHECK (b >= 0),
CONSTRAINT check_a CHECK (length(a) > 0)