Re: getting ERROR "relation 16401 has no triggers" with partition foreign key alter
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>,
pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2019-08-14T18:22:20Z
Lists: pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes: > On 2019-Jul-22, Alvaro Herrera wrote: >> After looking at the code some more, I think calling the new function in >> the Prep phase is correct. The attached patch is pretty much final form >> for this bugfix. I decided to unwrap a couple of error messages (I did >> get bitten while grepping because of this), and reordered one of the new >> Identity command cases in ATPrepCmd since it appeared in inconsistent >> order in that one place of four. > Pushed to all three branches. This is still listed as a live issue in https://wiki.postgresql.org/wiki/PostgreSQL_12_Open_Items#Live_issues Should that be closed now? regards, tom lane
Commits
-
Check that partitions are not in use when dropping constraints
- ec7f9a7407d3 11.5 landed
- 5562272a4229 13.0 landed
- 3ffe655c0af0 12.0 landed