pgsql: Prevent display of dropped columns in row constraint violation m

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Prevent display of dropped columns in row constraint violation m
Дата
Msg-id E1VeVSq-0007rK-1r@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Prevent display of dropped columns in row constraint violation messages.

ExecBuildSlotValueDescription() printed "null" for each dropped column in
a row being complained of by ExecConstraints().  This has some sanity in
terms of the underlying implementation, but is of course pretty surprising
to users.  To fix, we must pass the target relation's descriptor to
ExecBuildSlotValueDescription(), because the slot descriptor it had been
using doesn't get labeled with attisdropped markers.

Per bug #8408 from Maxim Boguk.  Back-patch to 9.2 where the feature of
printing row values in NOT NULL and CHECK constraint violation messages
was introduced.

Michael Paquier and Tom Lane

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c28b289bf365ab11f23460d02a43667f6a8b8bc7

Modified Files
--------------
src/backend/executor/execMain.c           |   47 +++++++++++++++++++++--------
src/test/regress/expected/alter_table.out |   14 +++++++++
src/test/regress/sql/alter_table.sql      |    9 ++++++
3 files changed, 57 insertions(+), 13 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix generation of MergeAppend plans for optimized min/max on exp
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Prevent display of dropped columns in row constraint violation m