Quick Links

Re: Trigger

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk>
Cc:	Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-general(at)postgresql(dot)org
Subject:	Re: Trigger
Date:	2003-10-23 13:44:28
Message-ID:	29256.1066916668@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)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

In response to

Re: Trigger at 2003-10-23 12:06:46 from Peter Childs

Responses

Re: Trigger at 2003-10-23 15:30:00 from Peter Childs

Browse pgsql-general by date

	From	Date	Subject
Next Message	Bruno BAGUETTE	2003-10-23 13:48:36	RE : Postgreqsl & Package
Previous Message	Alvaro Herrera	2003-10-23 13:34:50	Re: database files