summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTomas Vondra2017-09-26 20:13:20 +0000
committerTomas Vondra2017-09-26 20:13:20 +0000
commitd668b3081eb3797a6da84ce7d2ebd5e959b84b59 (patch)
tree298b80f8f5c55dd6c9bb7d01e7a95b32d50402a6
parent7fb4497f439f25362080a1891f06cbd493d55338 (diff)
Fix minor regression failure in updatable_views
The ATTACH PARTITION command was failing due to mismatching column order. That in turn caused failure in sanity_check, as the table was not dropped when dropping the parent.
-rw-r--r--src/test/regress/expected/updatable_views.out2
-rw-r--r--src/test/regress/sql/updatable_views.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/updatable_views.out b/src/test/regress/expected/updatable_views.out
index b9a54376ac..8a2c2b0879 100644
--- a/src/test/regress/expected/updatable_views.out
+++ b/src/test/regress/expected/updatable_views.out
@@ -2401,7 +2401,7 @@ insert into wcowrtest_v values (1);
ERROR: new row violates check option for view "wcowrtest_v"
DETAIL: Failing row contains (1).
alter table wcowrtest add b text;
-create table wcowrtest2 (b text, c int, a int);
+create table wcowrtest2 (a int, b text, c int);
alter table wcowrtest2 drop c;
alter table wcowrtest attach partition wcowrtest2 for values in (2);
create table sometable (a int, b text);
diff --git a/src/test/regress/sql/updatable_views.sql b/src/test/regress/sql/updatable_views.sql
index c8ebdeca52..2e28854c0c 100644
--- a/src/test/regress/sql/updatable_views.sql
+++ b/src/test/regress/sql/updatable_views.sql
@@ -1150,7 +1150,7 @@ create view wcowrtest_v as select * from wcowrtest where wcowrtest = '(2)'::wcow
insert into wcowrtest_v values (1);
alter table wcowrtest add b text;
-create table wcowrtest2 (b text, c int, a int);
+create table wcowrtest2 (a int, b text, c int);
alter table wcowrtest2 drop c;
alter table wcowrtest attach partition wcowrtest2 for values in (2);