Hello Guys, ERROR: could not convert table "b" to a view because it has triggers HINT: In particular, the table cannot be involved in any foreign key relationships.
********** Error ********** ERROR: could not convert table "b" to a view because it has triggers SQL state: 55000 Hint: In particular, the table cannot be involved in any foreign key relationships. Scenario: create table a (id int primary key); create table b (id int primary key, a_id int references a (id)); insert into a values (1); insert into b values (1,1); create table c AS SELECT * FROM b; TRUNCATE b; ALTER TABLE b DROP CONSTRAINT b_a_id_fkey; ALTER TABLE b DROP CONSTRAINT b_pkey; ALTER TABLE b ALTER COLUMN id DROP NOT NULL; CREATE RULE "_RETURN" AS ON SELECT TO b DO INSTEAD SELECT * FROM C;
