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)
