| PostgreSQL 9.3.1 中文手册 | ||||
|---|---|---|---|---|
| 上一页 | 上一级 | 章 37. 事件触发器 | 下一页 | |
表 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 | - |