Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitcadead6

Browse files
committed
Fix documentation on partitioning vs. foreign tables
1. The PARTITION OF clause of CREATE FOREIGN TABLE was not explained in the CREATE FOREIGN TABLE reference page. Add it. (Postgres 10 onwards)2. The limitation that tuple routing cannot target partitions that are foreign tables was not documented clearly enough. Improve wording. (Postgres 10 onwards)3. The UPDATE tuple re-routing concurrency behavior was explained in the DDL chapter, which doesn't seem the right place. Move it to the UPDATE reference page instead. (Postgres 11 onwards).Authors: Amit Langote, David Rowley.Reviewed-by: Etsuro Fujita.Reported-by: Derek HansDiscussion:https://postgr.es/m/CAGrP7a3Xc1Qy_B2WJcgAD8uQTS_NDcJn06O5mtS_Ne1nYhBsyw@mail.gmail.com
1 parentf9ec64d commitcadead6

File tree

1 file changed

+17
-0
lines changed

1 file changed

+17
-0
lines changed

‎doc/src/sgml/ref/create_foreign_table.sgml

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -160,6 +160,18 @@ CHECK ( <replaceable class="PARAMETER">expression</replaceable> ) [ NO INHERIT ]
160160
</listitem>
161161
</varlistentry>
162162

163+
<varlistentry>
164+
<term><literal>PARTITION OF <replaceable>parent_table</replaceable> FOR VALUES <replaceable class="PARAMETER">partition_bound_spec</replaceable></literal></term>
165+
<listitem>
166+
<para>
167+
This form can be used to create the foreign table as partition of
168+
the given parent table with specified partition bound values.
169+
See the similar form of
170+
<xref linkend="sql-createtable"> for more details.
171+
</para>
172+
</listitem>
173+
</varlistentry>
174+
163175
<varlistentry>
164176
<term><literal>CONSTRAINT <replaceable class="PARAMETER">constraint_name</replaceable></literal></term>
165177
<listitem>
@@ -308,6 +320,11 @@ CHECK ( <replaceable class="PARAMETER">expression</replaceable> ) [ NO INHERIT ]
308320
responsibility to ensure that the constraint definition matches
309321
reality.
310322
</para>
323+
324+
<para>
325+
Although foreign tables can be specified as partitions, routing of tuples
326+
to foreign-table partitions is not supported.
327+
</para>
311328
</refsect1>
312329

313330
<refsect1 id="SQL-CREATEFOREIGNTABLE-examples">

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp