logo - 跳到首页

VastbaseG100

基于openGauss内核开发的企业级关系型数据库。

Menu

DDL 命令触发矩阵

本节主要介绍 Vastbase 数据库中 DDL 命令与 DDL 触发事件的对应情况。

DDL 命令触发矩阵

下表列出了所有命令的 DDL 触发器触发情况。√ 表示可以触发，x 表示不会触发。

表 1 支持 DDL 触发器的命令标签

命令标签 ddl_​command_​start ddl_​command_​end sql_​drop table_​rewrite 备注
ALTER
{
AGGREGATE
| COLLATION
| CONVERSION
| DOMAIN
| DEFAULT PRIVILEGES
| EXTENSION
| FOREIGN DATA WRAPPER
| FUNCTION
| LANGUAGE
| LARGE OBJECT
| [ MATERIALIZED ] VIEW
| OPERATOR [ CLASS | FAMILY ]
| POLICY
| PROCEDURE
| PUBLICATION
| SCHEMA
| SEQUENCE
| SERVER
| STATISTICS
| SUBSCRIPTION
| TEXT SEARCH { CONFIGURATION | DICTIONARY | PARSER | TEMPLATE }
| TRIGGER | USER MAPPING
}
 √ √ X X
ALTER FOREIGN TABLE √ √ √ X
ALTER TABLE √ √ √ √
ALTER TYPE √ √ X √
COMMENT √ √ X X 仅对本地对象
CREATE
{
ACCESS METHOD
| AGGREGATE
| CAST
| COLLATION
| CONVERSION
| DOMAIN
| EXTENSION
| FOREIGN DATA WRAPPER
| FOREIGN TABLE
| FUNCTION
| INDEX
| LANGUAGE
| [ MATERIALIZED ] VIEW
| OPERATOR [ CLASS | FAMILY ]
| POLICY
| PROCEDURE
| PUBLICATION
| RULE
| SCHEMA
| SEQUENCE
| SERVER
| STATISTICS
| SUBSCRIPTION
| CREATE TABLE [AS]
| TEXT SEARCH { CONFIGURATION | DICTIONARY | PARSER | TEMPLATE }
| TRIGGER
| TYPE
| USER MAPPING
}
 √ √ X X
DROP
{
ACCESS METHOD
| AGGREGATE
| CAST
| COLLATION
| CONVERSION
| DOMAIN
| EXTENSION
| FOREIGN DATA WRAPPER
| FOREIGN TABLE
| FUNCTION
| INDEX
| LANGUAGE
| [ MATERIALIZED ] VIEW
| OPERATOR [ CLASS | FAMILY ]
| OWNED
| POLICY
| PROCEDURE
| PUBLICATION
| RULE
| SCHEMA
| SEQUENCE
| SERVER
| STATISTICS
| SUBSCRIPTION
| TABLE
| TEXT SEARCH { CONFIGURATION | DICTIONARY | PARSER | TEMPLATE }
| TRIGGER
| TYPE
| USER MAPPING
}
 √ √ √ X
GRANT √ √ X X 只对本地对象
IMPORT FOREIGN SCHEMA √ √ X X
REFRESH MATERIALIZED VIEW √ √ X X
REVOKE √ √ X X 只对本地对象
SECURITY LABEL √ √ X X 只对本地对象
SELECT INTO √ √ X X