Re: triggers on commit

On Fri, 19 Mar 2004 10:13:56 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Erik Thiele <erik(at)thiele-hydraulik(dot)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