NAME
CREATE CONSTRAINT TRIGGER - 定义一个新的约束触发器
SYNOPSIS
CREATE CONSTRAINT TRIGGER name AFTER events ON tablename constraint attributes FOR EACH ROW EXECUTE PROCEDURE funcname ( args )
DESCRIPTION 描述
CREATE CONSTRAINT TRIGGER 被 CREATE TABLE/ALTER TABLE 内部使用以及被 pg_dump 用于创建那些用于参考完整性的特殊的触发器。
PARAMETERS 参数
- name
约束触发器的名称。- events
触发该触发器的事件范围。- tablename
发生触发器事件的表名称(可能有模式修饰)。- constraint
实际的约束声明。- attributes
约束属性。- funcname(args)
触发器处理所调用的函数。
#p#
NAME
CREATE CONSTRAINT TRIGGER - define a new constraint trigger
SYNOPSIS
CREATE CONSTRAINT TRIGGER name AFTER events ON tablename constraint attributes FOR EACH ROW EXECUTE PROCEDURE funcname ( args )
DESCRIPTION
CREATE CONSTRAINT TRIGGER is used within CREATE TABLE/ALTER TABLE and by pg_dump to create the special triggers for referential integrity. It is not intended for general use.
PARAMETERS
- name
- The name of the constraint trigger.
- events
- The event categories for which this trigger should be fired.
- tablename
- The name (possibly schema-qualified) of the table in which the triggering events occur.
- constraint
- Actual constraint specification.
- attributes
- The constraint attributes.
- funcname(args)
- The function to call as part of the trigger processing.