Thank you for your answer. Without considering the errors, the transaction should not start after the AFTER INSERT? Josi Perez
2010/8/12 Tom Lane <t...@sss.pgh.pa.us> > "Josi Perez (3T Systems)" <josipere...@gmail.com> writes: > > If I write a trigger AFTER INSERT and I have one error in this trigger, > the > > record (that I think was already inserted) is not inserted. > > Sure, because the whole transaction is rolled back on error. > > regards, tom lane >
