> 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. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster