Quick Links

Re: trigger AFTER INSERT

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	"Josi Perez (3T Systems)" <josiperez3t(at)gmail(dot)com>
Cc:	pgsql-admin(at)postgresql(dot)org
Subject:	Re: trigger AFTER INSERT
Date:	2010-08-12 15:00:26
Message-ID:	14276.1281625226@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

"Josi Perez (3T Systems)" <josiperez3t(at)gmail(dot)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

In response to

trigger AFTER INSERT at 2010-08-12 14:58:53 from Josi Perez (3T Systems)

Responses

Re: trigger AFTER INSERT at 2010-08-16 16:06:29 from Josi Perez (3T Systems)

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Alvaro Herrera	2010-08-12 18:34:06	Re: Autovacuum daemon internal handling
Previous Message	Josi Perez (3T Systems)	2010-08-12 14:58:53	trigger AFTER INSERT