Re: triggers on commit

On Fri, 19 Mar 2004 10:13:56 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Erik Thiele <erik@thiele-hydraulik.de> 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