Re: Trigger

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