On Friday, February 24, 2017, Simon Riggs <
simon@2ndquadrant.com> wrote:
2. I know that DB2 handles this by having the user specify WITH ROW
MOVEMENT to explicitly indicate they accept the issue and want update
to work even with that. We could have an explicit option to allow
that. This appears to be the only way we could avoid silent errors for
foreign table partitions.
This does, however, make the partitioning very non-transparent to every update query just because it is remotely possible a partition-moving update might occur concurrently.
I dislike an error. I'd say that making partition "just work" here is material for another patch. In this one an update of the partition key can be documented as shorthand for delete-returning-insert with all the limitations that go with that. If someone acceptably solves the ctid following logic later it can be committed - I'm assuming there would be no complaints to making things just work in a case where they only sorta worked.
David J.