diff options
| author | Tom Lane | 2007-10-29 21:31:28 +0000 |
|---|---|---|
| committer | Tom Lane | 2007-10-29 21:31:28 +0000 |
| commit | 2aae35d049274b6364aa01add629c33a1e2e6089 (patch) | |
| tree | 5de315330bd9a39931704d4f67d26d803411eb64 /src/test | |
| parent | b17b7fae8c1418f924915348afaa2250d1360bc4 (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.out | 4 | ||||
| -rw-r--r-- | src/test/regress/expected/create_index.out | 2 |
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'; |
