getting ERROR "relation 16401 has no triggers" with partition foreignkey alter - Mailing list pgsql-hackers

From Rajkumar Raghuwanshi
Subject getting ERROR "relation 16401 has no triggers" with partition foreignkey alter
Date
Msg-id CAKcux6nZiO9-eEpr1ZD84bT1mBoVmeZkfont8iSpcmYrjhGWgA@mail.gmail.com
Whole thread Raw
Responses Re: getting ERROR "relation 16401 has no triggers" with partitionforeign key alter  (Michael Paquier <michael@paquier.xyz>)
Re: getting ERROR "relation 16401 has no triggers" with partition foreign key alter  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: refactoring - share str2*int64 functions
Next
From: Michael Paquier
Date:
Subject: Re: A little report on informal commit tag usage