On 2015-11-03 17:19:43 +1100, Haribabu Kommi wrote: > On Sat, Aug 29, 2015 at 12:55 PM, Thomas Munro > <thomas.mu...@enterprisedb.com> wrote: > > On Sat, Aug 29, 2015 at 9:03 AM, Thomas Munro > > <thomas.mu...@enterprisedb.com> wrote: > > This made me wonder what happens if a background worker calls LISTEN. > > NotifyMyFrontEnd simply logs the notifications, since there is no remote > > libpq to sent a message to. Perhaps a way of delivering to background > > workers could be developed, though of course there are plenty of other kinds > > of IPC available already. > > 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? Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers