pg10-foreign-table-limitations.patch
application/octet-stream
Filename: pg10-foreign-table-limitations.patch
Type: application/octet-stream
Part: 2
Patch
Format: unified
| File | + | − |
|---|---|---|
| doc/src/sgml/ref/create_foreign_table.sgml | 17 | 0 |
diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml
index 065c982082..ac41f3e495 100644
--- a/doc/src/sgml/ref/create_foreign_table.sgml
+++ b/doc/src/sgml/ref/create_foreign_table.sgml
@@ -160,6 +160,18 @@ CHECK ( <replaceable class="PARAMETER">expression</replaceable> ) [ NO INHERIT ]
</listitem>
</varlistentry>
+ <varlistentry>
+ <term><literal>PARTITION OF <replaceable>parent_table</replaceable> FOR VALUES <replaceable class="PARAMETER">partition_bound_spec</replaceable></literal></literal></term>
+ <listitem>
+ <para>
+ This form can be used to create the foreign table as partition of
+ the given parent table with speicified 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>
@@ -308,6 +320,11 @@ CHECK ( <replaceable class="PARAMETER">expression</replaceable> ) [ NO INHERIT ]
responsibility to ensure that the constraint definition matches
reality.
</para>
+
+ <para>
+ Although foreign tables can be specified as partitions, routing of tuples
+ to foreign-table partitions is not supported.
+ </para>
</refsect1>
<refsect1 id="SQL-CREATEFOREIGNTABLE-examples">