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