Re: Update does not move row across foreign partitions in v11

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: Update does not move row across foreign partitions in v11
Дата
Msg-id 16381946-c020-7099-f8fc-f5a8e11d6fb5@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Update does not move row across foreign partitions in v11  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Ответы Re: Update does not move row across foreign partitions in v11
Список pgsql-hackers
Fujita-san,

On 2019/03/06 15:10, Etsuro Fujita wrote:
> --- 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.

Thanks for checking.

I have updated the patch to include a line about this in the same
paragraph, because maybe we don't need to make a new <listitem> for it.

Thanks,
Amit

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tatsuro Yamada
Дата:
Сообщение: Re: [HACKERS] CLUSTER command progress monitor
Следующее
От: Tatsuro Yamada
Дата:
Сообщение: Re: [HACKERS] CLUSTER command progress monitor