Hi

I met a problem about trigger in logical replication.

I created a trigger after inserting data at subscriber, but there is a warning 
in the log of subscriber when the trigger fired:
WARNING: relcache reference leak: relation "xxx" not closed.

Example of the procedure:
------publisher------
create table test (a int primary key);
create publication pub for table test;

------subscriber------
create table test (a int primary key);
create subscription sub connection 'dbname=postgres' publication pub;
create function funcA() returns trigger as $$ begin return null; end; $$ 
language plpgsql;
create trigger my_trig after insert or update or delete on test for each row 
execute procedure funcA();
alter table test enable replica trigger my_trig;

------publisher------
insert into test values (6);

It seems an issue about reference leak. Anyone can fix this?

Regards,
Tang


Reply via email to