Horton

Re: getting ERROR "relation 16401 has no triggers" with partition foreign key alter

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2019-07-23T21:34:29Z
Lists: pgsql-hackers 
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.

Thanks for reporting

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

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