Horton

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

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2019-07-16T08:05:55Z
Lists: pgsql-hackers 
On Tue, Jul 16, 2019 at 01:07:45PM +0530, Rajkumar Raghuwanshi wrote:
> I am getting ERROR:  relation 16401 has no triggers error while executing
> below query.

Indeed, confirmed.  I can reproduce that down to v11, so that's not an
open item.  I have added an entry in the section for older issues
though.
--
Michael

Commits

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