From 618c9430a82860c84a3be2711eec2c3b43573b2a Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Mon, 8 Dec 2014 00:55:28 +0900 Subject: 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 --- src/backend/utils/cache/evtcache.c | 2 ++ 1 file changed, 2 insertions(+) (limited to 'src/backend/utils/cache') diff --git a/src/backend/utils/cache/evtcache.c b/src/backend/utils/cache/evtcache.c index ae71bd6bc7b..b9d442cdfc9 100644 --- a/src/backend/utils/cache/evtcache.c +++ b/src/backend/utils/cache/evtcache.c @@ -169,6 +169,8 @@ BuildEventTriggerCache(void) event = EVT_DDLCommandEnd; else if (strcmp(evtevent, "sql_drop") == 0) event = EVT_SQLDrop; + else if (strcmp(evtevent, "table_rewrite") == 0) + event = EVT_TableRewrite; else continue; -- cgit v1.2.3