On Thu, 23 Oct 2003, Tom Lane wrote:
> Peter Childs <[EMAIL PROTECTED]> writes: > > Great idea shame drivers to get at these are rare. Anyway you > > still need a trigger to fire the notify and these get sent when the query > > is done not when its commented. hmmm > > But the NOTIFY isn't delivered until and unless the transaction commits. > This gets around the AFTER-trigger-can-still-roll-back problem. > > regards, tom lane > Notify is also not very flexable it tells you somthing has triggerged it not the information that a trigger is supplied with, like what has changed to what from what. Peter Childs ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster