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