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

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

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.

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

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

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 > > >

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 -

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

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

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 > > >

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

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

[HACKERS] NOTIFY in Background Worker

2015-08-28 Thread jacques klein
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, They don't get lost, just not emited after the not forgotten call of

Re: [HACKERS] NOTIFY in Background Worker

2015-08-28 Thread Thomas Munro
On Sat, Aug 29, 2015 at 9:03 AM, Thomas Munro thomas.mu...@enterprisedb.com 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

Re: [HACKERS] NOTIFY in Background Worker

2015-08-28 Thread Thomas Munro
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 (other workers) don't get the notification until a NOTIFY chan is done for