]> granicus.if.org Git - postgresql/commit
pg_event_trigger_dropped_objects: add behavior flags
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Fri, 19 Dec 2014 18:00:45 +0000 (15:00 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Fri, 19 Dec 2014 18:00:45 +0000 (15:00 -0300)
commit0ee98d1cbf1cd3b888633b2ee90e0001889c12b9
treeedf24dba8ab9d9a08e4a5b138de36b07f5e4c0ee
parent5c805d0a813e6c611485bfc9bde9d2a10d1800e5
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.
doc/src/sgml/func.sgml
src/backend/catalog/dependency.c
src/backend/commands/event_trigger.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/commands/event_trigger.h
src/test/regress/expected/event_trigger.out
src/test/regress/sql/event_trigger.sql