From 50b10b8a9035842c223331dbb30cc065961aead1 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Wed, 12 Apr 2000 04:40:03 +0000 Subject: [PATCH] Fix up markup to allow building. Adjust two-word substitution parameters to be one word only to reduce possible ambiguity. --- doc/src/sgml/ref/create_table.sgml | 102 +++++++++++++++++------------ 1 file changed, 59 insertions(+), 43 deletions(-) diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 5102a2ad88..0e4642e912 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ @@ -451,13 +451,13 @@ CREATE TABLE distributors ( [ CONSTRAINT name ] { [ NULL | NOT NULL ] | UNIQUE | PRIMARY KEY | CHECK constraint | REFERENCES - referenced table - (referenced column) - [ MATCH match type ] + reftable + (refcolumn) + [ MATCH matchtype ] [ ON DELETE action ] [ ON UPDATE action ] [ [ NOT ] DEFERRABLE ] - [ INITIALLY check time ] } + [ INITIALLY checktime ] } [, ...] @@ -938,12 +938,12 @@ ERROR: Cannot insert a duplicate key into a unique index. [ CONSTRAINT name ] REFERENCES -referenced table [ ( referenced column ) ] +reftable [ ( refcolumn ) ] [ MATCH matchtype ] [ ON DELETE action ] [ ON UPDATE action ] [ [ NOT ] DEFERRABLE ] -[ INITIALLY check time ] +[ INITIALLY checktime ] The REFERENCES constraint specifies a rule that a column @@ -954,6 +954,7 @@ ERROR: Cannot insert a duplicate key into a unique index. Inputs + @@ -964,21 +965,23 @@ ERROR: Cannot insert a duplicate key into a unique index. + - referenced table + reftable The table that contains the data to check against. + - referenced column + refcolumn - The column in the referenced table + The column in reftable to check the data against. If this is not specified, the PRIMARY KEY of the - referenced table is used. + reftable is used. @@ -1096,6 +1099,7 @@ ERROR: Cannot insert a duplicate key into a unique index. + [ NOT ] DEFERRABLE @@ -1105,25 +1109,32 @@ ERROR: Cannot insert a duplicate key into a unique index. + - INITIALLY check time + INITIALLY checktime - check time has two possible values + checktime has two possible values which specify the default time to check the constraint. + DEFERRED - - Check this constraint at the end of the transaction. - + + + Check this constraint at the end of the transaction. + + + IMMEDIATE - - Check this constraint after each statement. - - + + + Check this constraint after each statement. + + + @@ -1150,7 +1161,7 @@ ERROR: Cannot insert a duplicate key into a unique index. ERROR: name referential integrity violation - key referenced from -table not found in referenced table +table not found in reftable @@ -1193,13 +1204,14 @@ ERROR: name referential integrity Currently Postgres only supports - MATCH FULL and an unspecified MATCH type. + MATCH FULL and an unspecified match type. In addition, the referenced columns are supposed to be the columns of a UNIQUE constraint in the referenced table, however Postgres does not enforce this. + @@ -1211,13 +1223,13 @@ ERROR: name referential integrity [ CONSTRAINT name ] { PRIMARY KEY | UNIQUE } ( column [, ...] ) [ CONSTRAINT name ] CHECK ( constraint ) [ CONSTRAINT name ] FOREIGN KEY ( column [, ...] ) - REFERENCES referenced table - (referenced column [, ...] ) - [ MATCH ] + REFERENCES reftable + (refcolumn [, ...] ) + [ MATCH matchtype ] [ ON DELETE action ] [ ON UPDATE action ] [ [ NOT ] DEFERRABLE ] - [ INITIALLY check time ] + [ INITIALLY checktime ] @@ -1464,7 +1476,7 @@ CREATE TABLE distributors ( - + 2000-02-04 @@ -1474,12 +1486,12 @@ CREATE TABLE distributors ( [ CONSTRAINT name ] FOREIGN KEY ( column [, ...] ) REFERENCES -referenced table [ ( referenced column [, ...] ) ] +reftable [ ( refcolumn [, ...] ) ] [ MATCH matchtype ] [ ON DELETE action ] [ ON UPDATE action ] [ [ NOT ] DEFERRABLE ] -[ INITIALLY check time ] +[ INITIALLY checktime ] The REFERENCES constraint specifies a rule that a column @@ -1488,7 +1500,7 @@ FOREIGN KEY ( column [, ...] ) REFE a FOREIGN KEY table constraint. - + Inputs @@ -1509,7 +1521,7 @@ FOREIGN KEY ( column [, ...] ) REFE - referenced table + reftable The table that contains the data to check against. @@ -1520,9 +1532,9 @@ FOREIGN KEY ( column [, ...] ) REFE referenced column [, ...] - One or more column in the referenced table + One or more column in the reftable to check the data against. If this is not specified, the PRIMARY KEY of the - referenced table is used. + reftable is used. @@ -1650,23 +1662,27 @@ FOREIGN KEY ( column [, ...] ) REFE - INITIALLY check time + INITIALLY checktime - check time has two possible values + checktime has two possible values which specify the default time to check the constraint. DEFERRED - - Check this constraint at the end of the transaction. - + + + Check this constraint at the end of the transaction. + + IMMEDIATE - - Check this constraint after each statement. - + + + Check this constraint after each statement. + + @@ -1675,7 +1691,7 @@ FOREIGN KEY ( column [, ...] ) REFE - + 2000-02-04 @@ -1692,7 +1708,7 @@ FOREIGN KEY ( column [, ...] ) REFE ERROR: name referential integrity violation - key referenced from -table not found in referenced table +table not found in reftable -- 2.40.0