39.2. Event Trigger Firing Matrix

Table 39.1 lists all commands for which event triggers are supported.

Table 39.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 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 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

-

-

Edit on GitHub