From 52831f791167901ed39742b16bccbc2ea37fa40f Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Mon, 16 Oct 2006 19:30:09 +0000
Subject: Update to CREATE CONSTRAINT manual page.
Michael Glaesemann
---
doc/src/sgml/ref/create_constraint.sgml | 163 +++++++++++++++++++-------------
1 file changed, 95 insertions(+), 68 deletions(-)
diff --git a/doc/src/sgml/ref/create_constraint.sgml b/doc/src/sgml/ref/create_constraint.sgml
index ef6db01053..582a684379 100644
--- a/doc/src/sgml/ref/create_constraint.sgml
+++ b/doc/src/sgml/ref/create_constraint.sgml
@@ -1,5 +1,5 @@
@@ -21,9 +21,12 @@ PostgreSQL documentation
CREATE CONSTRAINT TRIGGER name
- AFTER events ON
- tablename constraint attributes
- FOR EACH ROW EXECUTE PROCEDURE funcname ( args )
+ AFTER event [ OR ... ]
+ ON table_name
+ [ FROM referenced_table_name ]
+ { NOT DEFERRABLE | [ DEFERABBLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } }
+ FOR EACH ROW
+ EXECUTE PROCEDURE funcname ( arguments )
@@ -33,70 +36,94 @@ CREATE CONSTRAINT TRIGGER name
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.
-
-
+ 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. The actual name of the
+ created trigger will be of the form
+ RI_ConstraintTrigger_0000 (where 0000 is some number
+ assigned by the server).
+ Use this assigned name is when dropping the constraint.
+
+
+
+
+
+ events
+
+
+ One of INSERT, UPDATE, or
+ DELETE; this specifies the event that will fire the
+ trigger. Multiple events can be specified using OR.
+
+
+
+
+
+ table_name
+
+
+ The (possibly schema-qualified) name of the table in which
+ the triggering events occur.
+
+
+
+
+
+ referenced_table_name
+
+
+ The (possibly schema-qualified) name of the table referenced by the
+ constraint. Used by foreign key constraints triggers.
+
+
+
+
+
+ DEFERRABLE
+ NOT DEFERRABLE
+ INITIALLY IMMEDIATE
+ INITIALLY DEFERRED
+
+
+ See the
+ documentation for details of these constraint options.
+
+
+
+
+
+ funcname(args)
+
+
+ The function to call as part of the trigger processing. See for
+ details.
+
+
+
+
+
- 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.
-
-
-
-
+ Compatibility
+
+ CREATE CONTRAINT TRIGGER is a
+ PostgreSQL extension of the SQL
+ standard.
+
-
+
+
+
--
cgit v1.2.3