Re: BUG #15662: Row update in foreign partition does not move rowbased on partition key - Mailing list pgsql-bugs

From Derek Hans
Subject Re: BUG #15662: Row update in foreign partition does not move rowbased on partition key
Date
Msg-id CAGrP7a2vkbuu5RLd4yC4TP7nwpTbqLt5pfpS5a7-decy7yxq3w@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15662: Row update in foreign partition does not move row based on partition key  (Sergei Kornilov <sk@zsrv.org>)
Responses Re: BUG #15662: Row update in foreign partition does not move rowbased on partition key
List pgsql-bugs
Thanks. That's a substantial limitation. 

I looked pretty hard through the various pieces of documentation and tutorials and saw no mention. The v11 release notes don't mention it either. Might be worth adding to the docs in more places and more prominently.

On Fri, Mar 1, 2019 at 2:54 PM Sergei Kornilov <sk@zsrv.org> wrote:
Hello

This is known limitation and documented in the notes section of the UPDATE reference page:

> "Currently, rows cannot be moved from a partition that is a foreign table to some other partition, but they can be moved into a foreign table if the foreign data wrapper supports it."

https://www.postgresql.org/docs/11/sql-update.html

regards, Sergei


--

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15666: Seemingly incorrect error reporting/logging for violation of non-null constraint
Next
From: Tom Lane
Date:
Subject: Re: BUG #15666: Seemingly incorrect error reporting/logging for violation of non-null constraint