| From: | Artur Zakirov <artur(dot)zakirov(at)adjust(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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-15 12:03:25 |
| Message-ID: | CAFt03JOSvF2jvn76DmcZbjSFkw2BRTfWr9e1rPrN66LVT+bTkQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Wed, Sep 15, 2021 at 2:57 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Hearing no comments, I pushed that.
Thank you!
> > 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.
Indeed, it seems only regular backends can send out notifies to
frontends. In that case there is no point in supporting LISTEN to
other processes. I guess a background worker can try it with SPI, but
with no luck.
+1 from my sight.
--
Artur
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergei Kornilov | 2021-09-15 12:36:48 | Re: bugs or my fault |
| Previous Message | Yudianto Prasetyo | 2021-09-15 10:38:08 | Re: bugs or my fault |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcos Pegoraro | 2021-09-15 12:10:36 | Re: Trigger position |
| Previous Message | Alvaro Herrera | 2021-09-15 11:50:07 | Re: Column Filtering in Logical Replication |