pgsql: Improve unique-constraint-violation error messages to include the - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Improve unique-constraint-violation error messages to include the
Date
Msg-id 20090801195941.B77E275331E@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
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

Modified Files:
--------------
    pgsql/contrib/citext/expected:
        citext.out (r1.7 -> r1.8)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/citext/expected/citext.out?r1=1.7&r2=1.8)
        citext_1.out (r1.5 -> r1.6)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/citext/expected/citext_1.out?r1=1.5&r2=1.6)
    pgsql/src/backend/access/common:
        indextuple.c (r1.88 -> r1.89)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/common/indextuple.c?r1=1.88&r2=1.89)
    pgsql/src/backend/access/index:
        genam.c (r1.74 -> r1.75)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/index/genam.c?r1=1.74&r2=1.75)
    pgsql/src/backend/access/nbtree:
        nbtinsert.c (r1.171 -> r1.172)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtinsert.c?r1=1.171&r2=1.172)
    pgsql/src/backend/utils/adt:
        ri_triggers.c (r1.113 -> r1.114)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/ri_triggers.c?r1=1.113&r2=1.114)
        ruleutils.c (r1.305 -> r1.306)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/ruleutils.c?r1=1.305&r2=1.306)
    pgsql/src/include/access:
        genam.h (r1.79 -> r1.80)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/genam.h?r1=1.79&r2=1.80)
        itup.h (r1.51 -> r1.52)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/itup.h?r1=1.51&r2=1.52)
    pgsql/src/include/utils:
        builtins.h (r1.335 -> r1.336)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/builtins.h?r1=1.335&r2=1.336)
    pgsql/src/interfaces/ecpg/test/expected:
        compat_informix-test_informix.stderr (r1.12 -> r1.13)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/compat_informix-test_informix.stderr?r1=1.12&r2=1.13)
    pgsql/src/test/regress/expected:
        alter_table.out (r1.116 -> r1.117)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/alter_table.out?r1=1.116&r2=1.117)
        arrays.out (r1.48 -> r1.49)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/arrays.out?r1=1.48&r2=1.49)
        create_index.out (r1.31 -> r1.32)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/create_index.out?r1=1.31&r2=1.32)
        inherit.out (r1.26 -> r1.27)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/inherit.out?r1=1.26&r2=1.27)
        plpgsql.out (r1.71 -> r1.72)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/plpgsql.out?r1=1.71&r2=1.72)
        transactions.out (r1.18 -> r1.19)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/transactions.out?r1=1.18&r2=1.19)
        uuid.out (r1.4 -> r1.5)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/uuid.out?r1=1.4&r2=1.5)
    pgsql/src/test/regress/output:
        constraints.source (r1.44 -> r1.45)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/output/constraints.source?r1=1.44&r2=1.45)
        tablespace.source (r1.7 -> r1.8)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/output/tablespace.source?r1=1.7&r2=1.8)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Create a multiplexing structure for signals to Postgres child
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Department of second thoughts: let's show the exact key during