From 99cc10accc82184b38ac2990be5aa79d58ec3951 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Fri, 14 Apr 2000 15:17:28 +0000 Subject: [PATCH] Add mention of SET CONSTRAINT and CREATE CONSTRAINT TRIGGER. --- doc/src/sgml/ref/allfiles.sgml | 3 +- doc/src/sgml/ref/commands.sgml | 3 +- doc/src/sgml/ref/create_constraint.sgml | 150 ++++++++++++++++++++++++ doc/src/sgml/ref/set.sgml | 54 ++++++++- 4 files changed, 202 insertions(+), 8 deletions(-) create mode 100644 doc/src/sgml/ref/create_constraint.sgml diff --git a/doc/src/sgml/ref/allfiles.sgml b/doc/src/sgml/ref/allfiles.sgml index 89a7ed52c0..aef598d8a3 100644 --- a/doc/src/sgml/ref/allfiles.sgml +++ b/doc/src/sgml/ref/allfiles.sgml @@ -1,5 +1,5 @@ @@ -50,6 +50,7 @@ Complete list of usable sgml source files in this directory. + diff --git a/doc/src/sgml/ref/commands.sgml b/doc/src/sgml/ref/commands.sgml index 45f609647f..28f7f0cbde 100644 --- a/doc/src/sgml/ref/commands.sgml +++ b/doc/src/sgml/ref/commands.sgml @@ -1,5 +1,5 @@ @@ -24,6 +24,7 @@ Postgres documentation &commit; ©Table; &createAggregate; + &createConstraint; &createDatabase; &createFunction; &createGroup; diff --git a/doc/src/sgml/ref/create_constraint.sgml b/doc/src/sgml/ref/create_constraint.sgml new file mode 100644 index 0000000000..474b848a91 --- /dev/null +++ b/doc/src/sgml/ref/create_constraint.sgml @@ -0,0 +1,150 @@ + + + + + + CREATE CONSTRAINT TRIGGER + + SQL - Language Statements + + + + CREATE CONSTRAINT TRIGGER + + + Create a trigger to support a constraint + + + + + 2000-04-13 + + +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 + + + Table name of the triggering relation. + + + + + + constraint + + + Actual onstraint specification. + + + + + + attributes + + + Contraint attributes. + + + + + + func(args) + + + Function to call as part of the trigger processing. + + + + + + + + + + Outputs + + + + + + +CREATE CONSTRAINT + + + + Message returned if successful. + + + + + + + + + + + Description + + + CREATE CONSTRAINT TRIGGER is used from inside of + CREATE/ALTER TABLE and by + pg_dump to create the special triggers for + referential integrity. + + + + It is not intended for general use. + + + + + diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 76f6597547..0628ed673a 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -1,5 +1,5 @@ @@ -24,6 +24,7 @@ Postgres documentation SET variable { TO | = } { value | 'value' | DEFAULT } +SET CONSTRAINTS {ALL | constraintlist} mode SET TIME ZONE { 'timezone' | LOCAL | DEFAULT } SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } @@ -92,7 +93,7 @@ SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } - DateStyle + DATESTYLE Set the date/time representation style. Affects the output format, @@ -202,7 +203,7 @@ SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } - Seed + SEED Sets the internal seed for the random number generator. @@ -243,14 +244,14 @@ SELECT setseed(value); SERVER_ENCODING - Sets the multi-byte server encoding + Sets the multi-byte server encoding to: value - Sets the multi-byte server encoding. + The identifying value for the server encoding. @@ -265,6 +266,47 @@ SELECT setseed(value); + CONSTRAINT + + + SET CONSTRAINTS is the SQL3 specified command to change the + default behaviour of constraints with respect to deferring in the current + transaction. Allowed parameters are: + + + + constraintlist + + + Comma separated list of deferrable constraint names. + + + + + + mode + + + The constraint mode. Allowed values are + and . + + + + + + + + In deferred mode, the actual check of the constraint is held + back until either its mode is explicitly set to , + or until COMMIT. This is actually only done for foreign key + constraints, so it does not apply to UNIQUE or other + constraints. + + + + + + TIME ZONE TIMEZONE @@ -862,7 +904,7 @@ SET VARIABLE - Message returned if successfully. + Message returned if successful. -- 2.40.0