Event Trigger for table_rewrite Generate a table_rewrite event when ALTER TABLE attempts to rewrite a table. Provide helper functions to identify table and reason.
Intended use case is to help assess or to react to schema changes that might hold exclusive locks for long periods. Dimitri Fontaine, triggering an edit by Simon Riggs Reviewed in detail by Michael Paquier Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/618c9430a82860c84a3be2711eec2c3b43573b2a Modified Files -------------- doc/src/sgml/event-trigger.sgml | 150 +++++++++++++++++++++ doc/src/sgml/func.sgml | 85 ++++++++++-- src/backend/commands/event_trigger.c | 192 +++++++++++++++++++++++++-- src/backend/commands/tablecmds.c | 64 ++++++--- src/backend/utils/cache/evtcache.c | 2 + src/include/catalog/pg_proc.h | 4 + src/include/commands/event_trigger.h | 6 + src/include/utils/builtins.h | 2 + src/include/utils/evtcache.h | 3 +- src/test/regress/expected/event_trigger.out | 38 ++++++ src/test/regress/parallel_schedule | 5 +- src/test/regress/serial_schedule | 2 +- src/test/regress/sql/event_trigger.sql | 42 ++++++ 13 files changed, 556 insertions(+), 39 deletions(-) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
