Re: BUG #15662: Row update in foreign partition does not move rowbased on partition key

Поиск
Список
Период
Сортировка
От Derek Hans
Тема Re: BUG #15662: Row update in foreign partition does not move rowbased on partition key
Дата
Msg-id CAGrP7a2vkbuu5RLd4yC4TP7nwpTbqLt5pfpS5a7-decy7yxq3w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15662: Row update in foreign partition does not move row based on partition key  (Sergei Kornilov <sk@zsrv.org>)
Ответы Re: BUG #15662: Row update in foreign partition does not move rowbased on partition key
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15666: Seemingly incorrect error reporting/logging for violation of non-null constraint
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15666: Seemingly incorrect error reporting/logging for violation of non-null constraint