diff options
Diffstat (limited to 'src/test/regress/expected/alter_table.out')
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index 31278f89f0..f2e31919cc 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -411,7 +411,7 @@ create table atacc1 ( test int ); alter table atacc1 add constraint atacc_test1 check (test>3); -- should fail insert into atacc1 (test) values (2); -ERROR: ExecAppend: rejected due to CHECK constraint atacc_test1 +ERROR: ExecInsert: rejected due to CHECK constraint atacc_test1 -- should succeed insert into atacc1 (test) values (4); drop table atacc1; @@ -436,7 +436,7 @@ create table atacc1 ( test int, test2 int, test3 int); alter table atacc1 add constraint atacc_test1 check (test+test2<test3*4); -- should fail insert into atacc1 (test,test2,test3) values (4,4,2); -ERROR: ExecAppend: rejected due to CHECK constraint atacc_test1 +ERROR: ExecInsert: rejected due to CHECK constraint atacc_test1 -- should succeed insert into atacc1 (test,test2,test3) values (4,4,5); drop table atacc1; @@ -445,7 +445,7 @@ create table atacc1 (test int check (test>3), test2 int); alter table atacc1 add check (test2>test); -- should fail for $2 insert into atacc1 (test2, test) values (3, 4); -ERROR: ExecAppend: rejected due to CHECK constraint $2 +ERROR: ExecInsert: rejected due to CHECK constraint $2 drop table atacc1; -- inheritance related tests create table atacc1 (test int); @@ -454,11 +454,11 @@ create table atacc3 (test3 int) inherits (atacc1, atacc2); alter table atacc2 add constraint foo check (test2>0); -- fail and then succeed on atacc2 insert into atacc2 (test2) values (-3); -ERROR: ExecAppend: rejected due to CHECK constraint foo +ERROR: ExecInsert: rejected due to CHECK constraint foo insert into atacc2 (test2) values (3); -- fail and then succeed on atacc3 insert into atacc3 (test2) values (-3); -ERROR: ExecAppend: rejected due to CHECK constraint foo +ERROR: ExecInsert: rejected due to CHECK constraint foo insert into atacc3 (test2) values (3); drop table atacc3; drop table atacc2; @@ -470,7 +470,7 @@ create table atacc3 (test3 int) inherits (atacc1, atacc2); alter table only atacc2 add constraint foo check (test2>0); -- fail and then succeed on atacc2 insert into atacc2 (test2) values (-3); -ERROR: ExecAppend: rejected due to CHECK constraint foo +ERROR: ExecInsert: rejected due to CHECK constraint foo insert into atacc2 (test2) values (3); -- both succeed on atacc3 insert into atacc3 (test2) values (-3); @@ -608,7 +608,7 @@ insert into atacc1 (test2, test) values (3, 3); insert into atacc1 (test2, test) values (2, 3); ERROR: Cannot insert a duplicate key into unique index atacc1_pkey insert into atacc1 (test2, test) values (1, NULL); -ERROR: ExecAppend: Fail to add null value in not null attribute test +ERROR: ExecInsert: Fail to add null value in not null attribute test drop table atacc1; -- alter table / alter column [set/drop] not null tests -- try altering system catalogs, should fail @@ -658,9 +658,9 @@ create table parent (a int); create table child (b varchar(255)) inherits (parent); alter table parent alter a set not null; insert into parent values (NULL); -ERROR: ExecAppend: Fail to add null value in not null attribute a +ERROR: ExecInsert: Fail to add null value in not null attribute a insert into child (a, b) values (NULL, 'foo'); -ERROR: ExecAppend: Fail to add null value in not null attribute a +ERROR: ExecInsert: Fail to add null value in not null attribute a alter table parent alter a drop not null; insert into parent values (NULL); insert into child (a, b) values (NULL, 'foo'); @@ -671,14 +671,14 @@ ERROR: ALTER TABLE: Attribute "a" contains NULL values delete from parent; alter table only parent alter a set not null; insert into parent values (NULL); -ERROR: ExecAppend: Fail to add null value in not null attribute a +ERROR: ExecInsert: Fail to add null value in not null attribute a alter table child alter a set not null; insert into child (a, b) values (NULL, 'foo'); -ERROR: ExecAppend: Fail to add null value in not null attribute a +ERROR: ExecInsert: Fail to add null value in not null attribute a delete from child; alter table child alter a set not null; insert into child (a, b) values (NULL, 'foo'); -ERROR: ExecAppend: Fail to add null value in not null attribute a +ERROR: ExecInsert: Fail to add null value in not null attribute a drop table child; drop table parent; -- test setting and removing default values |