diff options
Diffstat (limited to '')
| -rw-r--r-- | doc/src/sgml/man7/CREATE_TABLE.7 | 20 |
1 files changed, 13 insertions, 7 deletions
diff --git a/doc/src/sgml/man7/CREATE_TABLE.7 b/doc/src/sgml/man7/CREATE_TABLE.7 index 02af742..13d806e 100644 --- a/doc/src/sgml/man7/CREATE_TABLE.7 +++ b/doc/src/sgml/man7/CREATE_TABLE.7 @@ -2,12 +2,12 @@ .\" Title: CREATE TABLE .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets vsnapshot <http://docbook.sf.net/> -.\" Date: 2023 -.\" Manual: PostgreSQL 15.5 Documentation -.\" Source: PostgreSQL 15.5 +.\" Date: 2024 +.\" Manual: PostgreSQL 15.6 Documentation +.\" Source: PostgreSQL 15.6 .\" Language: English .\" -.TH "CREATE TABLE" "7" "2023" "PostgreSQL 15.5" "PostgreSQL 15.5 Documentation" +.TH "CREATE TABLE" "7" "2024" "PostgreSQL 15.6" "PostgreSQL 15.6 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- @@ -747,7 +747,9 @@ These clauses specify a foreign key constraint, which requires that a group of o \fIrefcolumn\fR list is omitted, the primary key of the \fIreftable\fR -is used\&. The referenced columns must be the columns of a non\-deferrable unique or primary key constraint in the referenced table\&. The user must have +is used\&. Otherwise, the +\fIrefcolumn\fR +list must refer to the columns of a non\-deferrable unique or primary key constraint or be the columns of a non\-partial unique index\&. The user must have REFERENCES permission on the referenced table (either the whole table, or the specific referenced columns)\&. The addition of a foreign key constraint requires a SHARE ROW EXCLUSIVE @@ -1673,15 +1675,19 @@ EXCLUDE constraint type is a PostgreSQL extension\&. -.SS "Foreign\-Key Constraint Actions" +.SS "Foreign Key Constraints" .PP -The ability to specify column lists in the foreign\-key actions +The ability to specify column lists in the foreign key actions SET DEFAULT and SET NULL is a PostgreSQL extension\&. +.PP +It is a +PostgreSQL +extension that a foreign key constraint may reference columns of a unique index instead of columns of a primary key or unique constraint\&. .SS "NULL \(lqConstraint\(rq" .PP The |