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

Commit3e6b0c4

Browse files
author
Etsuro Fujita
committed
Doc: Update documentation on partitioning vs. foreign tables.
The limitations that it is not allowed to create/attach a foreign tableas a partition of an indexed partitioned table were not documented.Reported-By: Stepan YankevychAuthor: Etsuro FujitaReviewed-By: Amit LangoteBackpatch-through: 11 where partitioned index was introducedDiscussion:https://postgr.es/m/1553869152.858391073.5f8m3n0x@frv53.fwdcdn.com
1 parentedda32e commit3e6b0c4

File tree

2 files changed

+8
-0
lines changed

2 files changed

+8
-0
lines changed

‎doc/src/sgml/ref/alter_table.sgml

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -842,6 +842,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
842842
one will be created in the attached table; or, if an equivalent
843843
index already exists, will be attached to the target table's index,
844844
as if <command>ALTER INDEX ATTACH PARTITION</command> had been executed.
845+
Note that if the existing table is a foreign table, it is currently not
846+
allowed to attach the table as a partition of the target table if there
847+
are indexes on the target table. (See also
848+
<xref linkend="sql-createforeigntable"/>.)
845849
</para>
846850

847851
<para>

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

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -169,6 +169,10 @@ CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ]
169169
the given parent table with specified partition bound values.
170170
See the similar form of
171171
<xref linkend="sql-createtable"/> for more details.
172+
Note that it is currently not allowed to create the foreign table as a
173+
partition of the parent table if there are indexes on the parent table.
174+
(See also
175+
<link linkend="sql-altertable"><command>ALTER TABLE ATTACH PARTITION</command></link>.)
172176
</para>
173177
</listitem>
174178
</varlistentry>

0 commit comments

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