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

Commit7338ed2

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 parent392ea22 commit7338ed2

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
@@ -859,6 +859,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
859859
one will be created in the attached table; or, if an equivalent
860860
index already exists, will be attached to the target table's index,
861861
as if <command>ALTER INDEX ATTACH PARTITION</command> had been executed.
862+
Note that if the existing table is a foreign table, it is currently not
863+
allowed to attach the table as a partition of the target table if there
864+
are indexes on the target table. (See also
865+
<xref linkend="sql-createforeigntable"/>.)
862866
</para>
863867

864868
<para>

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

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

0 commit comments

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