diff options
author | Tomas Vondra | 2017-09-26 20:13:20 +0000 |
---|---|---|
committer | Tomas Vondra | 2017-09-26 20:13:20 +0000 |
commit | d668b3081eb3797a6da84ce7d2ebd5e959b84b59 (patch) | |
tree | 298b80f8f5c55dd6c9bb7d01e7a95b32d50402a6 | |
parent | 7fb4497f439f25362080a1891f06cbd493d55338 (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.out | 2 | ||||
-rw-r--r-- | src/test/regress/sql/updatable_views.sql | 2 |
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); |