Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16481: Stored Procedure Triggered by Logical Replication isUnable to use Notification Events - Mailing list pgsql-bugs

From Euler Taveira
Subject Re: BUG #16481: Stored Procedure Triggered by Logical Replication isUnable to use Notification Events
Date
Msg-id CAH503wAro5n_6o3bE3Xmij88Xoan4d_ytjG7rc=UX+NVE-dHFw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16481: Stored Procedure Triggered by Logical Replicationis Unable to use Notification Events  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: BUG #16481: Stored Procedure Triggered by Logical Replicationis Unable to use Notification Events  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Re: BUG #16481: Stored Procedure Triggered by Logical Replicationis Unable to use Notification Events  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
List pgsql-bugs
Tree view
On Mon, 8 Jun 2020 at 05:27, Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote:

That can be fixed by calling ProcessCompletedNotifies() in
apply_handle_commit. The function has a code to write out
notifications to connected clients but it doesn't nothing on logical
replication workers.


This bug was already reported some time ago (#15293) but it slipped through the
cracks. I don't think you should simply call ProcessCompletedNotifies [1].



--
Euler Taveira                 http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: Vianello Fabio
Date:
Subject: RE: BUG #16481: Stored Procedure Triggered by Logical Replication isUnable to use Notification Events
Next
From: Alvaro Herrera
Date:
Subject: Re: