Postgres Pro
Downloads
Home   >   mailing lists

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

From Sergei Kornilov
Subject Re: BUG #15662: Row update in foreign partition does not move row based on partition key
Date
Msg-id 14728891551470040@iva5-cb9df376e345.qloud-c.yandex.net
Whole thread Raw
In response to BUG #15662: Row update in foreign partition does not move row based on partition key  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15662: Row update in foreign partition does not move rowbased on partition key  (Derek Hans <derek.hans@gmail.com>)
List pgsql-bugs
Tree view 
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
movedinto 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 #15662: Row update in foreign partition does not move row based on partition key
Next
From: "Guy Rouillier"
Date:
Subject: Re: pgAdmin - Download as CSV