diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 12:18:09 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 12:18:09 +0000 |
commit | ebe124eacd7c3faa36ed358e7cc1d7c5b419e5f6 (patch) | |
tree | 48fe9c3270176faa25c7d9fb47326f689be82fe4 /doc/src/sgml/man7/CREATE_TABLE.7 | |
parent | Releasing progress-linux version 15.5-0+deb12u1~progress6.99u1. (diff) | |
download | postgresql-15-ebe124eacd7c3faa36ed358e7cc1d7c5b419e5f6.tar.xz postgresql-15-ebe124eacd7c3faa36ed358e7cc1d7c5b419e5f6.zip |
Merging upstream version 15.6.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'doc/src/sgml/man7/CREATE_TABLE.7')
-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 |