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

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: "derek(dot)hans(at)gmail(dot)com" <derek(dot)hans(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15662: Row update in foreign partition does not move row based on partition key
Date: 2019-03-01 19:54:00
Message-ID: 14728891551470040@iva5-cb9df376e345.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Guy Rouillier 2019-03-02 05:19:20 Re: pgAdmin - Download as CSV
Previous Message PG Bug reporting form 2019-03-01 19:06:48 BUG #15662: Row update in foreign partition does not move row based on partition key