On Fri, 19 Mar 2004 10:13:56 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> Erik Thiele <[EMAIL PROTECTED]> writes: > > now. what i wanted to do is ensure that this is done correctly and > > otherwise abort the transaction. > > of course this check needs to be done at the commit time, because if > > i do it on statement level, it cannot work, since i cannot change > > two tables at the same time. > > I believe "deferred AFTER" triggers are fired just before commit. i don't find this in the documentation. i only know triggers which run before insert/update/delete or directly (!) after, not waiting until commit. cya & thx! erik -- Erik Thiele ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
