Event Trigger Firing Matrix

PostgreSQL 9.5.25 Documentation
Prev	Up	Chapter 37. Event Triggers	Next

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

Table 37-1. Event Trigger Support by Command Tag

Command Tag	`ddl_command_start`	`ddl_command_end`	`sql_drop`	`table_rewrite`	Notes
`ALTER AGGREGATE`	`X`	`X`	`-`	`-`
`ALTER COLLATION`	`X`	`X`	`-`	`-`
`ALTER CONVERSION`	`X`	`X`	`-`	`-`
`ALTER DOMAIN`	`X`	`X`	`-`	`-`
`ALTER DEFAULT PRIVILEGES`	`X`	`X`	`-`	`-`
`ALTER EXTENSION`	`X`	`X`	`-`	`-`
`ALTER FOREIGN DATA WRAPPER`	`X`	`X`	`-`	`-`
`ALTER FOREIGN TABLE`	`X`	`X`	`X`	`-`
`ALTER FUNCTION`	`X`	`X`	`-`	`-`
`ALTER LANGUAGE`	`X`	`X`	`-`	`-`
`ALTER LARGE OBJECT`	`X`	`X`	`-`	`-`
`ALTER MATERIALIZED VIEW`	`X`	`X`	`-`	`-`
`ALTER OPERATOR`	`X`	`X`	`-`	`-`
`ALTER OPERATOR CLASS`	`X`	`X`	`-`	`-`
`ALTER OPERATOR FAMILY`	`X`	`X`	`-`	`-`
`ALTER POLICY`	`X`	`X`	`-`	`-`
`ALTER SCHEMA`	`X`	`X`	`-`	`-`
`ALTER SEQUENCE`	`X`	`X`	`-`	`-`
`ALTER SERVER`	`X`	`X`	`-`	`-`
`ALTER TABLE`	`X`	`X`	`X`	`X`
`ALTER TEXT SEARCH CONFIGURATION`	`X`	`X`	`-`	`-`
`ALTER TEXT SEARCH DICTIONARY`	`X`	`X`	`-`	`-`
`ALTER TEXT SEARCH PARSER`	`X`	`X`	`-`	`-`
`ALTER TEXT SEARCH TEMPLATE`	`X`	`X`	`-`	`-`
`ALTER TRIGGER`	`X`	`X`	`-`	`-`
`ALTER TYPE`	`X`	`X`	`-`	`X`
`ALTER USER MAPPING`	`X`	`X`	`-`	`-`
`ALTER VIEW`	`X`	`X`	`-`	`-`
`COMMENT`	`X`	`X`	`-`	`-`	Only for local objects
`CREATE AGGREGATE`	`X`	`X`	`-`	`-`
`CREATE CAST`	`X`	`X`	`-`	`-`
`CREATE COLLATION`	`X`	`X`	`-`	`-`
`CREATE CONVERSION`	`X`	`X`	`-`	`-`
`CREATE DOMAIN`	`X`	`X`	`-`	`-`
`CREATE EXTENSION`	`X`	`X`	`-`	`-`
`CREATE FOREIGN DATA WRAPPER`	`X`	`X`	`-`	`-`
`CREATE FOREIGN TABLE`	`X`	`X`	`-`	`-`
`CREATE FUNCTION`	`X`	`X`	`-`	`-`
`CREATE INDEX`	`X`	`X`	`-`	`-`
`CREATE LANGUAGE`	`X`	`X`	`-`	`-`
`CREATE MATERIALIZED VIEW`	`X`	`X`	`-`	`-`
`CREATE OPERATOR`	`X`	`X`	`-`	`-`
`CREATE OPERATOR CLASS`	`X`	`X`	`-`	`-`
`CREATE OPERATOR FAMILY`	`X`	`X`	`-`	`-`
`CREATE POLICY`	`X`	`X`	`-`	`-`
`CREATE RULE`	`X`	`X`	`-`	`-`
`CREATE SCHEMA`	`X`	`X`	`-`	`-`
`CREATE SEQUENCE`	`X`	`X`	`-`	`-`
`CREATE SERVER`	`X`	`X`	`-`	`-`
`CREATE TABLE`	`X`	`X`	`-`	`-`
`CREATE TABLE AS`	`X`	`X`	`-`	`-`
`CREATE TEXT SEARCH CONFIGURATION`	`X`	`X`	`-`	`-`
`CREATE TEXT SEARCH DICTIONARY`	`X`	`X`	`-`	`-`
`CREATE TEXT SEARCH PARSER`	`X`	`X`	`-`	`-`
`CREATE TEXT SEARCH TEMPLATE`	`X`	`X`	`-`	`-`
`CREATE TRIGGER`	`X`	`X`	`-`	`-`
`CREATE TYPE`	`X`	`X`	`-`	`-`
`CREATE USER MAPPING`	`X`	`X`	`-`	`-`
`CREATE VIEW`	`X`	`X`	`-`	`-`
`DROP AGGREGATE`	`X`	`X`	`X`	`-`
`DROP CAST`	`X`	`X`	`X`	`-`
`DROP COLLATION`	`X`	`X`	`X`	`-`
`DROP CONVERSION`	`X`	`X`	`X`	`-`
`DROP DOMAIN`	`X`	`X`	`X`	`-`
`DROP EXTENSION`	`X`	`X`	`X`	`-`
`DROP FOREIGN DATA WRAPPER`	`X`	`X`	`X`	`-`
`DROP FOREIGN TABLE`	`X`	`X`	`X`	`-`
`DROP FUNCTION`	`X`	`X`	`X`	`-`
`DROP INDEX`	`X`	`X`	`X`	`-`
`DROP LANGUAGE`	`X`	`X`	`X`	`-`
`DROP MATERIALIZED VIEW`	`X`	`X`	`X`	`-`
`DROP OPERATOR`	`X`	`X`	`X`	`-`
`DROP OPERATOR CLASS`	`X`	`X`	`X`	`-`
`DROP OPERATOR FAMILY`	`X`	`X`	`X`	`-`
`DROP OWNED`	`X`	`X`	`X`	`-`
`DROP POLICY`	`X`	`X`	`X`	`-`
`DROP RULE`	`X`	`X`	`X`	`-`
`DROP SCHEMA`	`X`	`X`	`X`	`-`
`DROP SEQUENCE`	`X`	`X`	`X`	`-`
`DROP SERVER`	`X`	`X`	`X`	`-`
`DROP TABLE`	`X`	`X`	`X`	`-`
`DROP TEXT SEARCH CONFIGURATION`	`X`	`X`	`X`	`-`
`DROP TEXT SEARCH DICTIONARY`	`X`	`X`	`X`	`-`
`DROP TEXT SEARCH PARSER`	`X`	`X`	`X`	`-`
`DROP TEXT SEARCH TEMPLATE`	`X`	`X`	`X`	`-`
`DROP TRIGGER`	`X`	`X`	`X`	`-`
`DROP TYPE`	`X`	`X`	`X`	`-`
`DROP USER MAPPING`	`X`	`X`	`X`	`-`
`DROP VIEW`	`X`	`X`	`X`	`-`
`GRANT`	`X`	`X`	`-`	`-`	Only for local objects
`IMPORT FOREIGN SCHEMA`	`X`	`X`	`-`	`-`
`REFRESH MATERIALIZED VIEW`	`X`	`X`	`-`	`-`
`REVOKE`	`X`	`X`	`-`	`-`	Only for local objects
`SECURITY LABEL`	`X`	`X`	`-`	`-`	Only for local objects
`SELECT INTO`	`X`	`X`	`-`	`-`

Prev	Home	Next
Overview of Event Trigger Behavior	Up	Writing Event Trigger Functions in C