On 1/3/08, Chris Browne <cbbrowne@xxxxxxx> wrote: > bruce@xxxxxxxxxx (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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
