pg_event_trigger_dropped_objects: add behavior flags
Alvaro Herrera <alvherre@alvh.no-ip.org>
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.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +13 −0 |
| src/backend/catalog/dependency.c | modified | +15 −6 |
| src/backend/commands/event_trigger.c | modified | +13 −3 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.h | modified | +1 −1 |
| src/include/commands/event_trigger.h | modified | +2 −1 |
| src/test/regress/expected/event_trigger.out | modified | +40 −0 |
| src/test/regress/sql/event_trigger.sql | modified | +30 −0 |