| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Artur Zakirov <artur(dot)zakirov(at)adjust(dot)com> |
| Cc: | Sergey Fedchenko <seregayoga(at)bk(dot)ru>, Daniel Danzberger <daniel(at)dd-wrt(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Sergei Kornilov <sk(at)zsrv(dot)org>, pgsql-hackers(at)postgresql(dot)org, Peter Eisentraut <peter_e(at)gmx(dot)net>, Marc Dean <marc(dot)dean(dot)jr(at)gmail(dot)com>, 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>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Robert Welin <robert(at)vaion(dot)com> |
| Subject: | Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events |
| Date: | 2021-09-14 21:56:58 |
| Message-ID: | 905668.1631656618@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
I wrote:
> Hence, I present the attached, which also tweaks things to avoid an
> extra pq_flush in the end-of-command code path, and improves the
> comments to discuss the issue of NOTIFYs sent by procedures.
Hearing no comments, I pushed that.
> I'm inclined to think we should flat-out reject LISTEN in any process
> that is not attached to a frontend, at least until somebody takes the
> trouble to add infrastructure that would let it be useful. I've not
> done that here though; I'm not quite sure what we should test for.
After a bit of looking around, it seems that MyBackendType addresses
that problem nicely, so I propose the attached.
regards, tom lane
| Attachment | Content-Type | Size |
|---|---|---|
| forbid-LISTEN-in-background.patch | text/x-diff | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yudianto Prasetyo | 2021-09-15 06:28:27 | bugs or my fault |
| Previous Message | Tom Lane | 2021-09-14 15:02:13 | Re: BUG #17158: Distinct ROW fails with Postgres 14 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jacob Champion | 2021-09-14 22:14:16 | Re: [PATCH] test/ssl: rework the sslfiles Makefile target |
| Previous Message | John Naylor | 2021-09-14 21:30:27 | Unicode 14.0.0 update |