pg_event_trigger_dropped_objects: add behavior flags
Add "normal" and "original" flags as output columns to the
pg_event_trigger_dropped_objects() function. With this it's possible to
distinguish which objects, among those listed, need to be explicitely
referenced when trying to replicate a deletion.
This is necessary so that the list of objects can be pruned to the
minimum necessary to replicate the DROP command in a remote server that
might have slightly different schema (for instance, TOAST tables and
constraints with different names and such.)
Catalog version bumped due to change of function definition.
Reviewed by: Abhijit Menon-Sen, Stephen Frost, Heikki Linnakangas,
Robert Haas.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/0ee98d1cbf1cd3b888633b2ee90e0001889c12b9
Modified Files
--------------
doc/src/sgml/func.sgml | 13 +++++++++
src/backend/catalog/dependency.c | 21 ++++++++++----
src/backend/commands/event_trigger.c | 16 +++++++++--
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.h | 2 +-
src/include/commands/event_trigger.h | 3 +-
src/test/regress/expected/event_trigger.out | 40 +++++++++++++++++++++++++++
src/test/regress/sql/event_trigger.sql | 30 ++++++++++++++++++++
8 files changed, 115 insertions(+), 12 deletions(-)