Re: [GENERAL] Feature request: NOTIFY enhancement

2008-01-04 Thread Marko Kreen
On 1/4/08, CN <[EMAIL PROTECTED]> wrote: > On Thu, 03 Jan 2008 14:20:41 -0500, "Chris Browne" <[EMAIL PROTECTED]> > said: > > > TODO already has: > > > > > > * Add optional textual message to NOTIFY > > > > > > This would allow an informational message to be added to the notify > > >

Re: [GENERAL] Feature request: NOTIFY enhancement

2008-01-04 Thread CN
On Thu, 03 Jan 2008 14:20:41 -0500, "Chris Browne" <[EMAIL PROTECTED]> said: > > TODO already has: > > > > * Add optional textual message to NOTIFY > > > > This would allow an informational message to be added to the notify > > message, perhaps indicating the row modified or ot

Re: [GENERAL] Feature request: NOTIFY enhancement

2008-01-04 Thread Marko Kreen
On 1/3/08, Chris Browne <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > >> I am not sure if I am asking too much but does it make sense, and is it > >> possible, to enhance NOTIFY that process "name/value" pair? Like this: > >> > >> NOTIFY "MyName=MyValue"; > >> > >> With t

Re: [GENERAL] Feature request: NOTIFY enhancement

2008-01-03 Thread Chris Browne
[EMAIL PROTECTED] (Bruce Momjian) writes: >> I am not sure if I am asking too much but does it make sense, and is it >> possible, to enhance NOTIFY that process "name/value" pair? Like this: >> >> NOTIFY "MyName=MyValue"; >> >> With the capability of name/value pair, the listener will not have to

Re: [GENERAL] Feature request: NOTIFY enhancement

2008-01-03 Thread Bruce Momjian
Alvaro Herrera wrote: > Andreas 'ads' Scherbaum wrote: > > > It is possible, that some notifies, if following in a very short time > > frame, can get lost. > > > > In case we want to send extra text messages with NOTIFY, we should make > > sure, that no notify get lost. > > Right. Currently, NO

Re: [GENERAL] Feature request: NOTIFY enhancement

2008-01-03 Thread Alvaro Herrera
Andreas 'ads' Scherbaum wrote: > It is possible, that some notifies, if following in a very short time > frame, can get lost. > > In case we want to send extra text messages with NOTIFY, we should make > sure, that no notify get lost. Right. Currently, NOTIFY acts like Unix signals -- consecuti

Re: [GENERAL] Feature request: NOTIFY enhancement

2008-01-03 Thread Bruce Momjian
Andreas 'ads' Scherbaum wrote: > > > With the capability of name/value pair, the listener will not have to > > > check notification details by reading tables. > > > > TODO already has: > > > > * Add optional textual message to NOTIFY > > > > This would allow an informational messag

Re: [GENERAL] Feature request: NOTIFY enhancement

2008-01-03 Thread Andreas 'ads' Scherbaum
Hello, On Thu, 3 Jan 2008 11:21:37 -0500 (EST) Bruce Momjian wrote: > > I am not sure if I am asking too much but does it make sense, and is it > > possible, to enhance NOTIFY that process "name/value" pair? Like this: > > > > NOTIFY "MyName=MyValue"; > > > > With the capability of name/value

Re: [GENERAL] Feature request: NOTIFY enhancement

2008-01-03 Thread Bruce Momjian
> I am not sure if I am asking too much but does it make sense, and is it > possible, to enhance NOTIFY that process "name/value" pair? Like this: > > NOTIFY "MyName=MyValue"; > > With the capability of name/value pair, the listener will not have to > check notification details by reading tables.

[GENERAL] Feature request: NOTIFY enhancement

2008-01-03 Thread CN
Dear developers, With the existing single-notification-value mechanism, not only SELECT'ing tables are necessary in some cases but DELETE'ing rows and synchronizing the DELETE are also required in many cases where there are multiple client connections to the same database. As an example, supposin