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
