Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)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 scenariowith a non-partitioned table you get
ERROR: 55006: cannot ALTER TABLE "tbl2" because it has pending trigger eventsLOCATION: CheckTableNotInUse, tablecmds.c:3436
but that test evidently fails to detect pending events for a partitionchild table.
regards, tom lane