Home   Interactive SQL for PostgreSQL   Download   Order
pgISQL help contents
Welcome!
Using ISQL
SQL Commands
ABORT
ALTER DATABASE
ALTER GROUP
ALTER TABLE
ALTER TRIGGER
ALTER USER
ANALYZE
BEGIN
CHECKPOINT
CLOSE
CLUSTER
COMMENT
COMMIT
COPY
CREATE AGGREGATE
CREATE CAST
CREATE CONSTRAINT TRIGGER
CREATE CONVERSION
CREATE DATABASE
CREATE DOMAIN
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE LANGUAGE
CREATE OPERATOR CLASS
CREATE OPERATOR
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE TABLE
CREATE TABLE AS
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
DEALLOCATE
DECLARE
DELETE
DROP AGGREGATE
DROP CAST
DROP CONVERSION
DROP DATABASE
DROP DOMAIN
DROP FUNCTION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP OPERATOR
DROP OPERATOR CLASS
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
END
EXECUTE
EXPLAIN
FETCH
GRANT
INSERT
LISTEN
LOAD
LOCK
MOVE
NOTIFY
PREPARE
REINDEX
RESET
REVOKE
ROLLBACK
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
START TRANSACTION
TRUNCATE
UNLISTEN
UPDATE
VACUUM

CREATE CONSTRAINT TRIGGER

Name

CREATE CONSTRAINT TRIGGER -- define a new constraint trigger

Synopsis

CREATE CONSTRAINT TRIGGER  name
    AFTER  events ON
     relation  constraint  attributes
    FOR EACH ROW EXECUTE PROCEDURE  func '('  args ')'

Inputs

name

The name of the constraint trigger.

events

The event categories for which this trigger should be fired.

relation

The name (possibly schema-qualified) of the relation in which the triggering events occur.

constraint

Actual constraint specification.

attributes

Constraint attributes.

func( args)

Function to call as part of the trigger processing.

Outputs

CREATE TRIGGER

Message returned if successful.

Description

CREATE CONSTRAINT TRIGGER is used within CREATE/ALTER TABLE and by pg_dump to create the special triggers for referential integrity.

It is not intended for general use.

This file was copied from PostgreSQL 7.3.1 help system.