summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorTom Lane2007-10-29 21:31:28 +0000
committerTom Lane2007-10-29 21:31:28 +0000
commit2aae35d049274b6364aa01add629c33a1e2e6089 (patch)
tree5de315330bd9a39931704d4f67d26d803411eb64 /src/test
parentb17b7fae8c1418f924915348afaa2250d1360bc4 (diff)
Mention the index name in 'could not create unique index' errors,
per suggestion from Rene Gollent.
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/alter_table.out4
-rw-r--r--src/test/regress/expected/create_index.out2
2 files changed, 3 insertions, 3 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out
index bf2d66af49..cba489d1d8 100644
--- a/src/test/regress/expected/alter_table.out
+++ b/src/test/regress/expected/alter_table.out
@@ -417,7 +417,7 @@ 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: could not create unique index
+ERROR: could not create unique index "atacc_test1"
DETAIL: Table contains duplicated values.
insert into atacc1 (test) values (3);
drop table atacc1;
@@ -485,7 +485,7 @@ 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: could not create unique index
+ERROR: could not create unique index "atacc_test1"
DETAIL: Table contains duplicated values.
insert into atacc1 (test) values (3);
drop table atacc1;
diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out
index 3483ba1555..b56078edf2 100644
--- a/src/test/regress/expected/create_index.out
+++ b/src/test/regress/expected/create_index.out
@@ -389,7 +389,7 @@ INSERT INTO concur_heap VALUES ('b','x');
ERROR: duplicate key value violates unique constraint "concur_index2"
-- check if constraint is enforced properly at build time
CREATE UNIQUE INDEX CONCURRENTLY concur_index3 ON concur_heap(f2);
-ERROR: could not create unique index
+ERROR: could not create unique index "concur_index3"
DETAIL: Table contains duplicated values.
-- test that expression indexes and partial indexes work concurrently
CREATE INDEX CONCURRENTLY concur_index4 on concur_heap(f2) WHERE f1='a';