PostgreSQL

40.2. Event Trigger Firing Matrix
Prev	Up	Chapter 40. Event Triggers	Home	Next

40.2. Event Trigger Firing Matrix

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

Table 40.1. Event Trigger Support by Command Tag

Command Tag ddl_command_start ddl_command_end sql_drop table_rewrite Notes

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`	`-`	`-`

ALTER AGGREGATE

X

-

ALTER COLLATION

X

-

ALTER CONVERSION

X

-

ALTER DOMAIN

X

-

ALTER DEFAULT PRIVILEGES

X

-

ALTER EXTENSION

X

-

ALTER FOREIGN DATA WRAPPER

X

-

ALTER FOREIGN TABLE

X

-

ALTER FUNCTION

X

-

ALTER LANGUAGE

X

-

ALTER LARGE OBJECT

X

-

ALTER MATERIALIZED VIEW

X

-

ALTER OPERATOR

X

-

ALTER OPERATOR CLASS

X

-

ALTER OPERATOR FAMILY

X

-

ALTER POLICY

X

-

ALTER PROCEDURE

X

-

ALTER PUBLICATION

X

-

ALTER ROUTINE

X

-

ALTER SCHEMA

X

-

ALTER SEQUENCE

X

-

ALTER SERVER

X

-

ALTER STATISTICS

X

-

ALTER SUBSCRIPTION

X

-

ALTER TABLE

X

ALTER TEXT SEARCH CONFIGURATION

X

-

ALTER TEXT SEARCH DICTIONARY

X

-

ALTER TEXT SEARCH PARSER

X

-

ALTER TEXT SEARCH TEMPLATE

X

-

ALTER TRIGGER

X

-

ALTER TYPE

X

-

X

ALTER USER MAPPING

X

-

ALTER VIEW

X

-

COMMENT

X

-

Only for local objects

CREATE ACCESS METHOD

X

-

CREATE AGGREGATE

X

-

CREATE CAST

X

-

CREATE COLLATION

X

-

CREATE CONVERSION

X

-

CREATE DOMAIN

X

-

CREATE EXTENSION

X

-

CREATE FOREIGN DATA WRAPPER

X

-

CREATE FOREIGN TABLE

X

-

CREATE FUNCTION

X

-

CREATE INDEX

X

-

CREATE LANGUAGE

X

-

CREATE MATERIALIZED VIEW

X

-

CREATE OPERATOR

X

-

CREATE OPERATOR CLASS

X

-

CREATE OPERATOR FAMILY

X

-

CREATE POLICY

X

-

CREATE PROCEDURE

X

-

CREATE PUBLICATION

X

-

CREATE RULE

X

-

CREATE SCHEMA

X

-

CREATE SEQUENCE

X

-

CREATE SERVER

X

-

CREATE STATISTICS

X

-

CREATE SUBSCRIPTION

X

-

CREATE TABLE

X

-

CREATE TABLE AS

X

-

CREATE TEXT SEARCH CONFIGURATION

X

-

CREATE TEXT SEARCH DICTIONARY

X

-

CREATE TEXT SEARCH PARSER

X

-

CREATE TEXT SEARCH TEMPLATE

X

-

CREATE TRIGGER

X

-

CREATE TYPE

X

-

CREATE USER MAPPING

X

-

CREATE VIEW

X

-

DROP ACCESS METHOD

X

-

DROP AGGREGATE

X

-

DROP CAST

X

-

DROP COLLATION

X

-

DROP CONVERSION

X

-

DROP DOMAIN

X

-

DROP EXTENSION

X

-

DROP FOREIGN DATA WRAPPER

X

-

DROP FOREIGN TABLE

X

-

DROP FUNCTION

X

-

DROP INDEX

X

-

DROP LANGUAGE

X

-

DROP MATERIALIZED VIEW

X

-

DROP OPERATOR

X

-

DROP OPERATOR CLASS

X

-

DROP OPERATOR FAMILY

X

-

DROP OWNED

X

-

DROP POLICY

X

-

DROP PROCEDURE

X

-

DROP PUBLICATION

X

-

DROP ROUTINE

X

-

DROP RULE

X

-

DROP SCHEMA

X

-

DROP SEQUENCE

X

-

DROP SERVER

X

-

DROP STATISTICS

X

-

DROP SUBSCRIPTION

X

-

DROP TABLE

X

-

DROP TEXT SEARCH CONFIGURATION

X

-

DROP TEXT SEARCH DICTIONARY

X

-

DROP TEXT SEARCH PARSER

X

-

DROP TEXT SEARCH TEMPLATE

X

-

DROP TRIGGER

X

-

DROP TYPE

X

-

DROP USER MAPPING

X

-

DROP VIEW

X

-

GRANT

X

-

Only for local objects

IMPORT FOREIGN SCHEMA

X

-

REFRESH MATERIALIZED VIEW

X

-

REVOKE

X

-

Only for local objects

SECURITY LABEL

X

-

Only for local objects

SELECT INTO

X

-

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

40.1. Overview of Event Trigger Behavior

Home

40.3. Writing Event Trigger Functions in C