Postgres Pro
Downloads
Home   >   mailing lists

Re: getting ERROR "relation 16401 has no triggers" with partition foreign key alter - Mailing list pgsql-hackers

From Tom Lane
Subject Re: getting ERROR "relation 16401 has no triggers" with partition foreign key alter
Date
Msg-id 7493.1563285592@sss.pgh.pa.us
Whole thread Raw
In response to getting ERROR "relation 16401 has no triggers" with partition foreignkey alter  (Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>)
Responses Re: getting ERROR "relation 16401 has no triggers" with partitionforeign key alter  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: refactoring - share str2*int64 functions
Next
From: Nikita Glukhov
Date:
Subject: Re: SQL/JSON: functions