On Thu, 23 Oct 2003, Tom Lane wrote:
> Peter Childs <blue.dragon@blueyonder.co.uk> 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