| From: | Marc Dean <marc(dot)dean(dot)jr(at)gmail(dot)com> |
|---|---|
| To: | Robert Welin <robert(at)vaion(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Sergei Kornilov <sk(at)zsrv(dot)org>, pgsql-hackers(at)postgresql(dot)org, Peter Eisentraut <peter_e(at)gmx(dot)net>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, "michael(dot)paul(dot)powers(at)gmail(dot)com" <michael(dot)paul(dot)powers(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events |
| Date: | 2019-02-28 01:01:16 |
| Message-ID: | CAEU75wAEjdV10eFtN7-uNyn5HO2MjyeqnAmN-d8w1tz=DrWgVg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
If you are trying to get around the issue for now, what my team did was
cron an insert statement on the database server. We have a queue table that
has some of these triggers setup so it was easy to write a no-op row to the
queue. This had the side effect of flushing the notification queue.
We haven't had any issues with this approach.
I can also volunteer to help test out patches.
Thanks,
-mdj
On Fri, Feb 22, 2019 at 11:37 AM Robert Welin <robert(at)vaion(dot)com> wrote:
> I have reproduced this bug on PostgreSQL version 10.7 and 11.2 using the
> steps described in Michael Powers' original report. The issue also still
> seems to be present even with the patch provided by Sergei Kornilov.
>
> Are there plans to address this issue any time soon or is there some way
> I can assist in fixing it? It would be great to have notifications from
> logical replication.
>
> Regards,
> Robert Welin
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2019-02-28 02:05:19 | Re: BUG #15659: missing comment "change requires restart" in postgresql.conf for parameter "data_sync_retry" |
| Previous Message | Jeremy Finzel | 2019-02-27 14:34:22 | Re: Segmentation Fault in logical decoding get/peek API |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tsunakawa, Takayuki | 2019-02-28 01:05:07 | RE: reloption to prevent VACUUM from truncating empty pages at the end of relation |
| Previous Message | Michael Paquier | 2019-02-28 00:54:45 | Re: get_controlfile() can leak fds in the backend |