表 40.1 列出了支持事件触发器的所有命令。
表 40.1. 按命令标记支持的事件触发器
命令标记 | ddl_command_start |
ddl_command_end |
sql_drop |
table_rewrite |
备注 |
---|---|---|---|---|---|
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 |
- |
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 |
- |
- |
仅适用于本地对象 |
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 |
- |
|
删除服务器 |
X |
X |
X |
- |
|
删除统计信息 |
X |
X |
X |
- |
|
删除订阅 |
X |
X |
X |
- |
|
删除表 |
X |
X |
X |
- |
|
删除文本搜索配置 |
X |
X |
X |
- |
|
删除文本搜索词典 |
X |
X |
X |
- |
|
删除文本搜索解析器 |
X |
X |
X |
- |
|
删除文本搜索模板 |
X |
X |
X |
- |
|
删除触发器 |
X |
X |
X |
- |
|
删除类型 |
X |
X |
X |
- |
|
删除用户映射 |
X |
X |
X |
- |
|
删除视图 |
X |
X |
X |
- |
|
授予 |
X |
X |
- |
- |
仅适用于本地对象 |
导入外部模式 |
X |
X |
- |
- |
|
刷新物化视图 |
X |
X |
- |
- |
|
撤销 |
X |
X |
- |
- |
仅适用于本地对象 |
安全标签 |
X |
X |
- |
- |
仅适用于本地对象 |
选择进入 |
X |
X |
- |
- |