aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/expected/insert.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/insert.out')
-rw-r--r--src/test/regress/expected/insert.out7
1 files changed, 7 insertions, 0 deletions
diff --git a/src/test/regress/expected/insert.out b/src/test/regress/expected/insert.out
index 383d8848471..ca3134c34c5 100644
--- a/src/test/regress/expected/insert.out
+++ b/src/test/regress/expected/insert.out
@@ -333,5 +333,12 @@ select tableoid::regclass, * from p;
p11 | 1 | 2
(1 row)
+truncate p;
+alter table p add constraint check_b check (b = 3);
+-- check that correct input row is shown when constraint check_b fails on p11
+-- after "(1, 2)" is routed to it
+insert into p values (1, 2);
+ERROR: new row for relation "p11" violates check constraint "check_b"
+DETAIL: Failing row contains (1, 2).
-- cleanup
drop table p, p1, p11;