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

From David Rowley
Subject Re: Update does not move row across foreign partitions in v11
Date
Msg-id CAKJS1f8Yb1zU3n0Yua0wRJK4Mv6XN5pr+H4Lk_PYnR+CSvSs2A@mail.gmail.com
Whole thread Raw
In response to Re: Update does not move row across foreign partitions in v11  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Responses Re: Update does not move row across foreign partitions in v11
List pgsql-hackers
On Sat, 9 Mar 2019 at 00:09, Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp> wrote:
> IMO I think it's better that we also mention that the UPDATE can move
> rows into a foreign partition if the FDW supports it.  No?

In my opinion, there's not much need to talk about what the
limitations are not when you're mentioning what the limitations are.
Maybe it would be worth it if the text was slightly unclear on what's
affected, but I thought my version was fairly clear.

If you think that it's still unclear, then I wouldn't object to adding
"  There is no such restriction on <command>UPDATE</command> row
movements out of native partitions into foreign ones.".  Obviously,
it's got to be clear for everyone, not just the person who wrote it.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Update does not move row across foreign partitions in v11
Next
From: Amit Kapila
Date:
Subject: Re: WIP: Avoid creation of the free space map for small tables