PostgreSQL 9.4.11 Documentation
PrevUpChapter 37. Event TriggersNext

37.2. Event Trigger Firing Matrix

Table 37-1 lists all commands for which event triggers are supported.

Table 37-1. Event Trigger Support by Command Tag

command tagddl_command_startddl_command_endsql_drop
ALTER AGGREGATEXX-
ALTER COLLATIONXX-
ALTER CONVERSIONXX-
ALTER DOMAINXX-
ALTER EXTENSIONXX-
ALTER FOREIGN DATA WRAPPERXX-
ALTER FOREIGN TABLEXXX
ALTER FUNCTIONXX-
ALTER LANGUAGEXX-
ALTER OPERATORXX-
ALTER OPERATOR CLASSXX-
ALTER OPERATOR FAMILYXX-
ALTER SCHEMAXX-
ALTER SEQUENCEXX-
ALTER SERVERXX-
ALTER TABLEXXX
ALTER TEXT SEARCH CONFIGURATIONXX-
ALTER TEXT SEARCH DICTIONARYXX-
ALTER TEXT SEARCH PARSERXX-
ALTER TEXT SEARCH TEMPLATEXX-
ALTER TRIGGERXX-
ALTER TYPEXX-
ALTER USER MAPPINGXX-
ALTER VIEWXX-
CREATE AGGREGATEXX-
CREATE CASTXX-
CREATE COLLATIONXX-
CREATE CONVERSIONXX-
CREATE DOMAINXX-
CREATE EXTENSIONXX-
CREATE FOREIGN DATA WRAPPERXX-
CREATE FOREIGN TABLEXX-
CREATE FUNCTIONXX-
CREATE INDEXXX-
CREATE LANGUAGEXX-
CREATE OPERATORXX-
CREATE OPERATOR CLASSXX-
CREATE OPERATOR FAMILYXX-
CREATE RULEXX-
CREATE SCHEMAXX-
CREATE SEQUENCEXX-
CREATE SERVERXX-
CREATE TABLEXX-
CREATE TABLE ASXX-
CREATE TEXT SEARCH CONFIGURATIONXX-
CREATE TEXT SEARCH DICTIONARYXX-
CREATE TEXT SEARCH PARSERXX-
CREATE TEXT SEARCH TEMPLATEXX-
CREATE TRIGGERXX-
CREATE TYPEXX-
CREATE USER MAPPINGXX-
CREATE VIEWXX-
DROP AGGREGATEXXX
DROP CASTXXX
DROP COLLATIONXXX
DROP CONVERSIONXXX
DROP DOMAINXXX
DROP EXTENSIONXXX
DROP FOREIGN DATA WRAPPERXXX
DROP FOREIGN TABLEXXX
DROP FUNCTIONXXX
DROP INDEXXXX
DROP LANGUAGEXXX
DROP OPERATORXXX
DROP OPERATOR CLASSXXX
DROP OPERATOR FAMILYXXX
DROP OWNEDXXX
DROP RULEXXX
DROP SCHEMAXXX
DROP SEQUENCEXXX
DROP SERVERXXX
DROP TABLEXXX
DROP TEXT SEARCH CONFIGURATIONXXX
DROP TEXT SEARCH DICTIONARYXXX
DROP TEXT SEARCH PARSERXXX
DROP TEXT SEARCH TEMPLATEXXX
DROP TRIGGERXXX
DROP TYPEXXX
DROP USER MAPPINGXXX
DROP VIEWXXX
SELECT INTOXX-
PrevHomeNext
Overview of Event Trigger BehaviorUpWriting Event Trigger Functions in C