Fujita-san,
On 2019/03/06 15:10, Etsuro Fujita wrote:
> --- a/doc/src/sgml/ddl.sgml
> +++ b/doc/src/sgml/ddl.sgml
> @@ -3376,6 +3376,13 @@ ALTER TABLE measurement ATTACH PARTITION
> measurement_y2008m02
> </para>
> </listitem>
>
> + <listitem>
> + <para>
> + <command>UPDATE</command> row movement is not supported in the cases
> + where the old row is contained in a foreign table partition.
> + </para>
> + </listitem>
>
> ISTM that it's also a limitation that rows can be moved from a local
> partition to a foreign partition *if the FDW support tuple routing*, so I
> would vote for mentioning that as well here.
Thanks for checking.
I have updated the patch to include a line about this in the same
paragraph, because maybe we don't need to make a new <listitem> for it.
Thanks,
Amit
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index 8314fce78f..c6b5bd0e54 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -3878,6 +3878,15 @@ ALTER TABLE measurement ATTACH PARTITION
measurement_y2008m02
<listitem>
<para>
+ <command>UPDATE</command> row movement is not supported in the cases
+ where the old row is contained in a foreign table partition. Also,
+ moving the new row into a foreign table partition is supported only
+ if the table's FDW supports tuple routing.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>BEFORE ROW</literal> triggers, if necessary, must be defined
on individual partitions, not the partitioned table.
</para>
