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(-)
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. |