From ebe124eacd7c3faa36ed358e7cc1d7c5b419e5f6 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:18:09 +0200 Subject: Merging upstream version 15.6. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/sql-createtable.html | 21 +++++++++++++-------- 1 file changed, 13 insertions(+), 8 deletions(-) (limited to 'doc/src/sgml/html/sql-createtable.html') diff --git a/doc/src/sgml/html/sql-createtable.html b/doc/src/sgml/html/sql-createtable.html index 473703b..d902ffe 100644 --- a/doc/src/sgml/html/sql-createtable.html +++ b/doc/src/sgml/html/sql-createtable.html @@ -1,5 +1,5 @@ -CREATE TABLE
CREATE TABLE
Prev UpSQL CommandsHome Next

CREATE TABLE

CREATE TABLE — define a new table

Synopsis

+CREATE TABLE
CREATE TABLE
Prev UpSQL CommandsHome Next
CREATE TABLE
CREATE TABLE — define a new table
Synopsis
 CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [
   { column_name data_type [ COMPRESSION compression_method ] [ COLLATE collation ] [ column_constraint [ ... ] ]
     | table_constraint
@@ -705,10 +705,11 @@ WITH ( MODULUS numeric_literal, REMAIN
       contain values that match values in the referenced
       column(s) of some row of the referenced table.  If the refcolumn list is omitted, the
       primary key of the reftable
-      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 REFERENCES permission on the referenced table
-      (either the whole table, or the specific referenced columns).  The
+      is used.  Otherwise, the refcolumn
+      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 lock on the referenced table.
       Note that foreign key constraints cannot be defined between temporary
@@ -1389,10 +1390,14 @@ CREATE TABLE cities_partdef
    
EXCLUDE Constraint

     The EXCLUDE constraint type is a
     PostgreSQL extension.
-   
Foreign-Key Constraint Actions

-    The ability to specify column lists in the foreign-key actions
+   
Foreign Key Constraints

+    The ability to specify column lists in the foreign key actions
     SET DEFAULT and SET NULL is a
     PostgreSQL extension.
+   

+    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.
    
NULL “Constraint”

     The NULL “constraint” (actually a
     non-constraint) is a PostgreSQL
@@ -1467,4 +1472,4 @@ CREATE TABLE cities_partdef
    
PARTITION OF Clause

     The PARTITION OF clause is a
     PostgreSQL extension.
-
Prev Up Next
CREATE SUBSCRIPTION Home CREATE TABLE AS
\ No newline at end of file +

Prev Up Next
CREATE SUBSCRIPTION Home CREATE TABLE AS
\ No newline at end of file -- cgit v1.2.3