Re: Feature request: NOTIFY enhancement

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 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 message to be added to the notify
>       message, perhaps indicating the row modified or other custom
>       information.

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.


Kind regards

--
                Andreas 'ads' Scherbaum
German PostgreSQL User Group