• Alvaro Herrera's avatar
    pg_event_trigger_dropped_objects: add behavior flags · 0ee98d1c
    Alvaro Herrera authored
    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.
    0ee98d1c
event_trigger.sql 9.14 KB