(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
