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.