pgsql.cc 提供对 postgresql.org 官网内容的中文翻译,由 Pigsty 团队维护。
表 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 |
- |
译文有误、术语不当或页面显示问题,请到译文仓库 pgsty/pgdoc 报告译文问题。 英文原文本身的问题,请在当前版本的对应页面向上游反馈;上游不再修订已结束维护的版本。