summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian2000-07-16 19:27:29 +0000
committerBruce Momjian2000-07-16 19:27:29 +0000
commit8a70a1c75d69af74f1d72cb7cebd50108a7ae3f5 (patch)
tree5b27f4d11171650df27521c60a256e86b750634b
parent0d59dad7701e0ec7b4fb9689b9f6b7dc5f7b23e3 (diff)
Hmm. I didn't expect a change since I hadn't added tests for the new
stuff, but fixing the bug that existed in reporting the constraint name changes the error line. Patch to expected output enclosed. Stephan Szabo
-rw-r--r--src/test/regress/expected/alter_table.out2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out
index 80010b965bd..a0fef3b55ee 100644
--- a/src/test/regress/expected/alter_table.out
+++ b/src/test/regress/expected/alter_table.out
@@ -285,7 +285,7 @@ INSERT INTO tmp3 values (5,50);
-- Try (and fail) to add constraint due to invalid data
ALTER TABLE tmp3 add constraint tmpconstr foreign key (a) references tmp2 match full;
NOTICE: ALTER TABLE ... ADD CONSTRAINT will create implicit trigger(s) for FOREIGN KEY check(s)
-ERROR: <unnamed> referential integrity violation - key referenced from tmp3 not found in tmp2
+ERROR: tmpconstr referential integrity violation - key referenced from tmp3 not found in tmp2
-- Delete failing row
DELETE FROM tmp3 where a=5;
-- Try (and succeed)