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

  1. Check that partitions are not in use when dropping constraints