diff options
Diffstat (limited to 'src/test/regress/expected/alter_table.out')
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index ea4524dd54..677dce17ea 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -475,7 +475,7 @@ NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "atacc_test1" for t insert into atacc1 (test) values (2); -- should fail insert into atacc1 (test) values (2); -ERROR: Cannot insert a duplicate key into unique index atacc_test1 +ERROR: duplicate key violates UNIQUE constraint "atacc_test1" -- should succeed insert into atacc1 (test) values (4); -- try adding a unique oid constraint @@ -509,7 +509,7 @@ NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "atacc_test1" for t insert into atacc1 (test,test2) values (4,4); -- should fail insert into atacc1 (test,test2) values (4,4); -ERROR: Cannot insert a duplicate key into unique index atacc_test1 +ERROR: duplicate key violates UNIQUE constraint "atacc_test1" -- should all succeed insert into atacc1 (test,test2) values (4,5); insert into atacc1 (test,test2) values (5,4); @@ -523,7 +523,7 @@ NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "atacc1_test2_key" -- should fail for @@ second one @@ 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_test_key +ERROR: duplicate key violates UNIQUE constraint "atacc1_test_key" drop table atacc1; -- test primary key constraint adding create table atacc1 ( test int ); @@ -534,7 +534,7 @@ NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "atacc_test1" insert into atacc1 (test) values (2); -- should fail insert into atacc1 (test) values (2); -ERROR: Cannot insert a duplicate key into unique index atacc_test1 +ERROR: duplicate key violates UNIQUE constraint "atacc_test1" -- should succeed insert into atacc1 (test) values (4); -- inserting NULL should fail @@ -589,7 +589,7 @@ ERROR: multiple primary keys for table "atacc1" are not allowed insert into atacc1 (test,test2) values (4,4); -- should fail insert into atacc1 (test,test2) values (4,4); -ERROR: Cannot insert a duplicate key into unique index atacc_test1 +ERROR: duplicate key violates UNIQUE constraint "atacc_test1" insert into atacc1 (test,test2) values (NULL,3); ERROR: null value for attribute "test" violates NOT NULL constraint insert into atacc1 (test,test2) values (3, NULL); @@ -607,7 +607,7 @@ NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "atacc1_pkey" for -- only first should succeed 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 +ERROR: duplicate key violates UNIQUE constraint "atacc1_pkey" insert into atacc1 (test2, test) values (1, NULL); ERROR: null value for attribute "test" violates NOT NULL constraint drop table atacc1; |