Postgres Pro
Downloads
Home   >   mailing lists

Re: trigger AFTER INSERT - Mailing list pgsql-admin

From Tom Lane
Subject Re: trigger AFTER INSERT
Date
Msg-id 14276.1281625226@sss.pgh.pa.us
Whole thread Raw
In response to trigger AFTER INSERT  ("Josi Perez (3T Systems)" <josiperez3t@gmail.com>)
Responses Re: trigger AFTER INSERT  ("Josi Perez (3T Systems)" <josiperez3t@gmail.com>)
List pgsql-admin
Tree view 
"Josi Perez (3T Systems)" <josiperez3t@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

pgsql-admin by date:

Previous
From: "Josi Perez (3T Systems)"
Date:
Subject: trigger AFTER INSERT
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum daemon internal handling