aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/create_foreign_table.sgml
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src/sgml/ref/create_foreign_table.sgml')
-rw-r--r--doc/src/sgml/ref/create_foreign_table.sgml18
1 files changed, 18 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml
index 37a45b26dbc..19eb5341e7d 100644
--- a/doc/src/sgml/ref/create_foreign_table.sgml
+++ b/doc/src/sgml/ref/create_foreign_table.sgml
@@ -161,6 +161,18 @@ CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ]
</varlistentry>
<varlistentry>
+ <term><literal>PARTITION OF <replaceable>parent_table</replaceable> FOR VALUES <replaceable class="parameter">partition_bound_spec</replaceable></literal></term>
+ <listitem>
+ <para>
+ This form can be used to create the foreign table as partition of
+ the given parent table with specified partition bound values.
+ See the similar form of
+ <xref linkend="sql-createtable"/> for more details.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term><literal>CONSTRAINT <replaceable class="parameter">constraint_name</replaceable></literal></term>
<listitem>
<para>
@@ -308,6 +320,12 @@ CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ]
responsibility to ensure that the constraint definition matches
reality.
</para>
+
+ <para>
+ While rows can be moved from local partitions to a foreign-table partition
+ (provided the foreign data wrapper supports tuple routing), they cannot be
+ moved from a foreign-table partition to another partition.
+ </para>
</refsect1>
<refsect1 id="sql-createforeigntable-examples">