事件触发器触发矩阵

PostgreSQL 9.4.4 中文手册
上一页 | 上一级 | 章 37. 事件触发器 | 下一页

# 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 EXTENSION` | `X` | `X` | `-`
`ALTER FOREIGN DATA WRAPPER` | `X` | `X` | `-`
`ALTER FOREIGN TABLE` | `X` | `X` | `X`
`ALTER FUNCTION` | `X` | `X` | `-`
`ALTER LANGUAGE` | `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 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 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` | `-`

上一页 | 起始页 | 下一页
事件触发器行为的概述 | 上一级 | 用C编写事件触发器函数