历史版本。 PostgreSQL 9.4 已结束支持。 2020-02-13. 请参阅 当前版本手册.
37.2. 事件触发器触发矩阵 #
表 37.1列出了事件触发器所支持的所有命令。
表 37.1. 按命令标签分类的事件触发器支持
| 命令标签 | ddl_command_start | ddl_command_end | sql_drop |
|---|---|---|---|
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 SCHEMA | X | X | - |
ALTER SEQUENCE | X | X | - |
ALTER SERVER | X | X | - |
ALTER TABLE | 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 | - |
ALTER USER MAPPING | X | X | - |
ALTER VIEW | 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 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 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 |
SELECT INTO | X | X | - |