Postgres Pro
Downloads
Home   >   mailing lists

Re: NOTIFY in Background Worker - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: NOTIFY in Background Worker
Date
Msg-id CANP8+jJT5t10dAd3+R5EiG98f=iikgRTgtnaHgoa_4M_HFP3cA@mail.gmail.com
Whole thread Raw
In response to Re: NOTIFY in Background Worker  (Andres Freund <andres@anarazel.de>)
Responses Re: NOTIFY in Background Worker
List pgsql-hackers
Tree view
On 3 November 2015 at 09:35, Andres Freund <andres@anarazel.de> wrote:
 
> With this commit - bde39eed0cafb82bc94c40e95d96b5cf47b6f719, it is not possible
> to execute Notify commands inside a parallel worker. Can't we change
> it as disable both listen and notify commands inside a background worker?

Well, parallel workers are something different from general background
workers. I don't see why it'd make sense to allow listen/notify there,
given the rest of the restrictions?

What are the restrictions and/or where are they documented? Thanks

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

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: pglogical_output - a general purpose logical decoding output plugin
Next
From: Pavel Stehule
Date:
Subject: Re: NOTIFY in Background Worker