aboutsummaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2003-07-25 20:18:01 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2003-07-25 20:18:01 +0000
commit689eb53e478debe0232e4fb928a0d6aae33fa34c (patch)
tree5113d4f2b03c9ec6d756bf53117dbb189a735b68 /src/test
parent9fecf302f79a49f132e8a61b8f073959fa1ed1fd (diff)
downloadpostgresql-689eb53e478debe0232e4fb928a0d6aae33fa34c.tar.gz
postgresql-689eb53e478debe0232e4fb928a0d6aae33fa34c.zip
Error message editing in backend/utils (except /adt).
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/alter_table.out6
1 files changed, 4 insertions, 2 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out
index 19e60662c7f..8a8cfeef5b8 100644
--- a/src/test/regress/expected/alter_table.out
+++ b/src/test/regress/expected/alter_table.out
@@ -491,7 +491,8 @@ insert into atacc1 (test) values (2);
-- add a unique constraint (fails)
alter table atacc1 add constraint atacc_test1 unique (test);
NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "atacc_test1" for table "atacc1"
-ERROR: Cannot create unique index. Table contains non-unique values
+ERROR: could not create unique index
+DETAIL: Table contains duplicated values.
insert into atacc1 (test) values (3);
drop table atacc1;
-- let's do one where the unique constraint fails
@@ -558,7 +559,8 @@ insert into atacc1 (test) values (2);
-- add a primary key (fails)
alter table atacc1 add constraint atacc_test1 primary key (test);
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "atacc_test1" for table "atacc1"
-ERROR: Cannot create unique index. Table contains non-unique values
+ERROR: could not create unique index
+DETAIL: Table contains duplicated values.
insert into atacc1 (test) values (3);
drop table atacc1;
-- let's do another one where the primary key constraint fails when added