Re: [HACKERS] NOTIFY in Background Worker

2015-11-05 Thread Robert Haas
On Thu, Nov 5, 2015 at 11:46 PM, Thomas Munro wrote: >> Yes, the above description is good. > > +1 Committed that way, then. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To mak

Re: [HACKERS] NOTIFY in Background Worker

2015-11-05 Thread Thomas Munro
On Fri, Nov 6, 2015 at 12:08 PM, Haribabu Kommi wrote: > On Fri, Nov 6, 2015 at 4:57 AM, Robert Haas wrote: > > On Thu, Nov 5, 2015 at 12:34 AM, Haribabu Kommi > > wrote: > >> I marked this patch as ready for committer. > > > > The patch says: > > > > If a background worker registers to receive

Re: [HACKERS] NOTIFY in Background Worker

2015-11-05 Thread Haribabu Kommi
On Fri, Nov 6, 2015 at 4:57 AM, Robert Haas wrote: > On Thu, Nov 5, 2015 at 12:34 AM, Haribabu Kommi > wrote: >> I marked this patch as ready for committer. > > The patch says: > > If a background worker registers to receive asynchronous notifications > with the LISTEN through SPI, > there is cur

Re: [HACKERS] NOTIFY in Background Worker

2015-11-05 Thread Robert Haas
On Thu, Nov 5, 2015 at 12:34 AM, Haribabu Kommi wrote: > I marked this patch as ready for committer. The patch says: If a background worker registers to receive asynchronous notifications with the LISTEN through SPI, there is currently no way for incoming notifications to be received. But would

Re: [HACKERS] NOTIFY in Background Worker

2015-11-04 Thread Haribabu Kommi
On Sat, Aug 29, 2015 at 12:55 PM, Thomas Munro wrote: > On Sat, Aug 29, 2015 at 9:03 AM, Thomas Munro > wrote: >> >> On Fri, Aug 28, 2015 at 10:30 PM, jacques klein >> wrote: >>> >>> Hello, >>> >>> I added a "NOFITY chan" to the SQL arg of an SPI_execute(), (I did it >>> also with just the NOTIF

Re: [HACKERS] NOTIFY in Background Worker

2015-11-03 Thread Pavel Stehule
2015-11-03 9:54 GMT+01:00 Andres Freund : > On 2015-11-03 09:52:26 +0100, Pavel Stehule wrote: > > 2015-11-03 9:35 GMT+01:00 Andres Freund : > > > > > On 2015-11-03 17:19:43 +1100, Haribabu Kommi wrote: > > > > With this commit - bde39eed0cafb82bc94c40e95d96b5cf47b6f719, it is > not > > > possible

Re: [HACKERS] NOTIFY in Background Worker

2015-11-03 Thread Andres Freund
On 2015-11-03 09:52:34 +0100, Simon Riggs wrote: > On 3 November 2015 at 09:35, Andres Freund 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 l

Re: [HACKERS] NOTIFY in Background Worker

2015-11-03 Thread Andres Freund
On 2015-11-03 09:52:26 +0100, Pavel Stehule wrote: > 2015-11-03 9:35 GMT+01:00 Andres Freund : > > > On 2015-11-03 17:19:43 +1100, Haribabu Kommi wrote: > > > With this commit - bde39eed0cafb82bc94c40e95d96b5cf47b6f719, it is not > > possible > > > to execute Notify commands inside a parallel work

Re: [HACKERS] NOTIFY in Background Worker

2015-11-03 Thread Pavel Stehule
2015-11-03 9:35 GMT+01:00 Andres Freund : > On 2015-11-03 17:19:43 +1100, Haribabu Kommi wrote: > > On Sat, Aug 29, 2015 at 12:55 PM, Thomas Munro > > wrote: > > > On Sat, Aug 29, 2015 at 9:03 AM, Thomas Munro > > > wrote: > > > This made me wonder what happens if a background worker calls LISTE

Re: [HACKERS] NOTIFY in Background Worker

2015-11-03 Thread Simon Riggs
On 3 November 2015 at 09:35, Andres Freund 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,

Re: [HACKERS] NOTIFY in Background Worker

2015-11-03 Thread Andres Freund
On 2015-11-03 17:19:43 +1100, Haribabu Kommi wrote: > On Sat, Aug 29, 2015 at 12:55 PM, Thomas Munro > wrote: > > On Sat, Aug 29, 2015 at 9:03 AM, Thomas Munro > > wrote: > > This made me wonder what happens if a background worker calls LISTEN. > > NotifyMyFrontEnd simply logs the notifications,

Re: [HACKERS] NOTIFY in Background Worker

2015-11-02 Thread Haribabu Kommi
On Sat, Aug 29, 2015 at 12:55 PM, Thomas Munro wrote: > On Sat, Aug 29, 2015 at 9:03 AM, Thomas Munro > wrote: >> >> On Fri, Aug 28, 2015 at 10:30 PM, jacques klein >> wrote: >>> >>> Hello, >>> >>> I added a "NOFITY chan" to the SQL arg of an SPI_execute(), (I did it >>> also with just the NOTIF

Re: [HACKERS] NOTIFY in Background Worker

2015-08-28 Thread Thomas Munro
On Sat, Aug 29, 2015 at 9:03 AM, Thomas Munro wrote: > On Fri, Aug 28, 2015 at 10:30 PM, jacques klein < > jacques.k...@googlemail.com> wrote: > >> Hello, >> >> I added a "NOFITY chan" to the SQL arg of an SPI_execute(), (I did it >> also with just the NOTIFY statement), >> but the listeners (oth

Re: [HACKERS] NOTIFY in Background Worker

2015-08-28 Thread Thomas Munro
On Fri, Aug 28, 2015 at 10:30 PM, jacques klein wrote: > Hello, > > I added a "NOFITY chan" to the SQL arg of an SPI_execute(), (I did it also > with just the NOTIFY statement), > but the listeners (other workers) don't get the notification until a > "NOTIFY chan" is done for example with pgadmin