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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: getting ERROR "relation 16401 has no triggers" with partition foreign key alter
Date: 2019-07-16 13:59:52
Message-ID: 7493.1563285592@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nikita Glukhov 2019-07-16 13:59:58 Re: SQL/JSON: functions
Previous Message Tom Lane 2019-07-16 13:41:05 Re: refactoring - share str2*int64 functions