Re: a misbehavior of partition row movement (?) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: a misbehavior of partition row movement (?)
Date
Msg-id 202201111123.2jgx5lnzecdf@alvherre.pgsql
Whole thread Raw
In response to Re: a misbehavior of partition row movement (?)  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: a misbehavior of partition row movement (?)
List pgsql-hackers
On 2022-Jan-11, Amit Langote wrote:

> As for the fix to make cross-partition updates work correctly with
> foreign keys, I just realized it won't work for the users' existing
> foreign keys, because the parent table's triggers that are needed for
> the fix to work would not be present.  Were you thinking that we'd ask
> users of v13 and v14 to drop and recreate those constraints?

Yeah, more or less.  Also, any tables created from 13.6 onwards.

I was mainly thinking that we'll still have people creating new clusters
using pg13 for half a decade.

-- 
Álvaro Herrera              Valdivia, Chile  —  https://www.EnterpriseDB.com/
"Right now the sectors on the hard disk run clockwise, but I heard a rumor that
you can squeeze 0.2% more throughput by running them counterclockwise.
It's worth the effort. Recommended."  (Gerry Pourwelle)



pgsql-hackers by date:

Previous
From: RKN Sai Krishna
Date:
Subject: Query regarding replication slots
Next
From: Denis Hirn
Date:
Subject: Re: [PATCH] Allow multiple recursive self-references