Re: Update does not move row across foreign partitions in v11 - Mailing list pgsql-hackers

(2019/03/06 13:18), Amit Langote wrote:
> The main problem here is indeed that the limitation is not listed under
> the partitioning limitations in ddl.sgml, where it's easier to notice than
> in the UPDATE's page.

Agreed.

> I've updated my patch to remove the release-11.sgml
> changes.

Thanks for the updated patch!

--- 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.

Best regards,
Etsuro Fujita