Event Trigger for table_rewrite
Simon Riggs <simon@2ndQuadrant.com>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/event-trigger.sgml | modified | +150 −0 |
| doc/src/sgml/func.sgml | modified | +77 −8 |
| src/backend/commands/event_trigger.c | modified | +184 −8 |
| src/backend/commands/tablecmds.c | modified | +45 −19 |
| src/backend/utils/cache/evtcache.c | modified | +2 −0 |
| src/include/catalog/pg_proc.h | modified | +4 −0 |
| src/include/commands/event_trigger.h | modified | +6 −0 |
| src/include/utils/builtins.h | modified | +2 −0 |
| src/include/utils/evtcache.h | modified | +2 −1 |
| src/test/regress/expected/event_trigger.out | modified | +38 −0 |
| src/test/regress/parallel_schedule | modified | +3 −2 |
| src/test/regress/serial_schedule | modified | +1 −1 |
| src/test/regress/sql/event_trigger.sql | modified | +42 −0 |