38.2. Event Trigger Firing Matrix
Table 38.1 lists all commands for which event triggers are supported.
Table 38.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 PROCEDURE | X | X | - | - | Â |
ALTER PUBLICATION | X | X | - | - | Â |
ALTER ROUTINE | X | X | - | - | Â |
ALTER SCHEMA | X | X | - | - | Â |
ALTER SEQUENCE | X | X | - | - | Â |
ALTER SERVER | X | X | - | - | Â |
ALTER STATISTICS | X | X | - | - | Â |
ALTER SUBSCRIPTION | 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 ACCESS METHOD | X | X | - | - | Â |
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 PROCEDURE | X | X | - | - | Â |
CREATE PUBLICATION | X | X | - | - | Â |
CREATE RULE | X | X | - | - | Â |
CREATE SCHEMA | X | X | - | - | Â |
CREATE SEQUENCE | X | X | - | - | Â |
CREATE SERVER | X | X | - | - | Â |
CREATE STATISTICS | X | X | - | - | Â |
CREATE SUBSCRIPTION | 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 ACCESS METHOD | X | 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 PROCEDURE | X | X | X | - | Â |
DROP PUBLICATION | X | X | X | - | Â |
DROP ROUTINE | X | X | X | - | Â |
DROP RULE | X | X | X | - | Â |
DROP SCHEMA | X | X | X | - | Â |
DROP SEQUENCE | X | X | X | - | Â |
DROP SERVER | X | X | X | - | Â |
DROP STATISTICS | X | X | X | - | Â |
DROP SUBSCRIPTION | 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 | - | - | Â |