pgsql: Add tg_updatedcols to TriggerData

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add tg_updatedcols to TriggerData
Date: 2020-03-09 08:38:54
Message-ID: E1jBDw6-0005kc-Mr@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add tg_updatedcols to TriggerData

This allows a trigger function to determine for an UPDATE trigger
which columns were actually updated. This allows some optimizations
in generic trigger functions such as lo_manage and
tsvector_update_trigger.

Reviewed-by: Daniel Gustafsson <daniel(at)yesql(dot)se>
Discussion: https://www.postgresql.org/message-id/flat/11c5f156-67a9-0fb5-8200-2a8018eb2e0c(at)2ndquadrant(dot)com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/71d60e2aa05157efec28393b15c0b0b9fc1b210c

Modified Files
--------------
contrib/lo/expected/lo.out | 8 ++++++++
contrib/lo/lo.c | 3 ++-
contrib/lo/sql/lo.sql | 5 +++++
doc/src/sgml/trigger.sgml | 25 +++++++++++++++++++++++++
src/backend/commands/trigger.c | 6 ++++++
src/backend/utils/adt/tsvector_op.c | 29 +++++++++++++++++++++--------
src/include/commands/trigger.h | 1 +
7 files changed, 68 insertions(+), 9 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2020-03-09 15:52:33 pgsql: Fix bug that causes to report waiting in PS display twice, in ho
Previous Message Fujii Masao 2020-03-09 06:45:03 pgsql: Avoid assertion failure with targeted recovery in standby mode.