pgsql: pg_event_trigger_dropped_objects: add behavior flags

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: pg_event_trigger_dropped_objects: add behavior flags
Date: 2014-12-19 18:04:48
Message-ID: E1Y21uy-0006c7-EG@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2014-12-20 01:56:07 pgsql: doc: Adjust wording of ALTER TABLESPACE restriction
Previous Message Heikki Linnakangas 2014-12-19 15:07:38 pgsql: Fix timestamp in end-of-recovery WAL records.