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

On 2019-Jul-17, Alvaro Herrera wrote:

> I think we should just run CheckTableNotInUse for each partition in
> ATExecDropConstraint.  Trying that out now.

Actually, that doesn't fix this problem, because the partitioned side is
the *referencing* side, and ATExecDropConstraint is obsessed about the
*referenced* side only and assumes that the calling code has already
dealt with the referencing side checks.  I'm trying a fix for that now.

I wonder if there are other AT subcommands that are similarly broken,
because many of them skip the CheckTableNotInUse for the partitions.

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