On 1/3/08, Chris Browne <cbbrowne@acm.org> wrote:
> bruce@momjian.us (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
> >> 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.
>
> I keep wondering if this isn't just going to grow into pgq...
>
> <http://docs.huihoo.com/api/skytools/pgq-module.html>
>
> In effect, once you start defining more semantics for this, I think it
> rapidly transforms into a message queueing system, and you might as
> well go straight to something full-fledged like pgq...
Sligtly better link for PgQ:
https://developer.skype.com/SkypeGarage/DbProjects/SkyTools#head-65d9b2775e38524d7ce3f3940700cdf924480bc6
--
marko