Re: [SQL] triggers on commit

2004-03-19 Thread Erik Thiele
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 > >

Re: [SQL] triggers on commit

2004-03-19 Thread Tom Lane
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