Hi, I am getting ERROR: relation 16401 has no triggers error while executing below query.
postgres=# create table tbl1(f1 int primary key); CREATE TABLE postgres=# create table tbl2(f1 int references tbl1 deferrable initially deferred) partition by range(f1); CREATE TABLE postgres=# create table tbl2_p1 partition of tbl2 for values from (minvalue) to (maxvalue); CREATE TABLE postgres=# insert into tbl1 values(1); INSERT 0 1 postgres=# begin; BEGIN postgres=# insert into tbl2 values(1); INSERT 0 1 postgres=# alter table tbl2 drop constraint tbl2_f1_fkey; ALTER TABLE postgres=# commit; ERROR: relation 16395 has no triggers Thanks & Regards, Rajkumar Raghuwanshi QMG, EnterpriseDB Corporation
