Re: Trigger - Mailing list pgsql-general

From Tom Lane
Subject Re: Trigger
Date
Msg-id 29256.1066916668@sss.pgh.pa.us
Whole thread Raw
In response to Re: Trigger  (Peter Childs <blue.dragon@blueyonder.co.uk>)
Responses Re: Trigger  (Peter Childs <blue.dragon@blueyonder.co.uk>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: database files
Next
From: "Bruno BAGUETTE"
Date:
Subject: RE : Postgreqsl & Package