Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2019-07-16T13:59:52Z
Lists: pgsql-hackers 
Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com> writes:
> I am getting ERROR:  relation 16401 has no triggers error while executing
> below query.

Yeah, I can reproduce that back to v11.  If you try the same scenario
with a non-partitioned table you get

ERROR:  55006: cannot ALTER TABLE "tbl2" because it has pending trigger events
LOCATION:  CheckTableNotInUse, tablecmds.c:3436

but that test evidently fails to detect pending events for a partition
child table.

			regards, tom lane

Commits

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