document-update-row-movement-limitation-v2.patch

text/plain

Filename: document-update-row-movement-limitation-v2.patch
Type: text/plain
Part: 0
Message: Re: Update does not move row across foreign partitions in v11

Patch

Format: unified
Series: patch v2
File+
doc/src/sgml/ddl.sgml 9 0
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>