Re: trigger AFTER INSERT

["Josi Perez (3T Systems)" <josiperez3t@xxxxxxxxx>]

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 <tgl@xxxxxxxxxxxxx>

"Josi Perez (3T Systems)" <josiperez3t@xxxxxxxxx> 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