Horton

Improve unique-constraint-violation error messages to include the exact

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: b680ae4bdbf1c7fd78e6988bbe8f89e1e1b5db86
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2009-08-01T19:59:41Z
Releases: 9.0.0 
Improve unique-constraint-violation error messages to include the exact
values being complained of.

In passing, also remove the arbitrary length limitation in the similar
error detail message for foreign key violations.

Itagaki Takahiro

Files

PathChange+/−
contrib/citext/expected/citext_1.out modified +3 −0
contrib/citext/expected/citext.out modified +3 −0
src/backend/access/common/indextuple.c modified +22 −1
src/backend/access/index/genam.c modified +56 −1
src/backend/access/nbtree/nbtinsert.c modified +19 −6
src/backend/utils/adt/ri_triggers.c modified +12 −20
src/backend/utils/adt/ruleutils.c modified +23 −10
src/include/access/genam.h modified +3 −1
src/include/access/itup.h modified +3 −1
src/include/utils/builtins.h modified +2 −1
src/interfaces/ecpg/test/expected/compat_informix-test_informix.stderr modified +1 −0
src/test/regress/expected/alter_table.out modified +6 −0
src/test/regress/expected/arrays.out modified +1 −0
src/test/regress/expected/create_index.out modified +3 −0
src/test/regress/expected/inherit.out modified +2 −0
src/test/regress/expected/plpgsql.out modified +2 −0
src/test/regress/expected/transactions.out modified +2 −0
src/test/regress/expected/uuid.out modified +1 −0
src/test/regress/output/constraints.source modified +8 −0
src/test/regress/output/tablespace.source modified +1 −0