Re: trigger AFTER INSERT

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Josi Perez (3T Systems)" <josiperez3t(at)gmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: trigger AFTER INSERT
Date: 2010-08-16 16:39:27
Message-ID: 4C69236F020000250003469A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Josi Perez (3T Systems)" <josiperez3t(at)gmail(dot)com> wrote:

> Without considering the errors, the transaction should not start
> after the AFTER INSERT?

Anything happening in a trigger is always part of the same database
transaction as the database action which fired the trigger.

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Koczan 2010-08-16 18:08:31 Is regular vacuuming with autovacuum needed?
Previous Message Josi Perez (3T Systems) 2010-08-16 16:06:29 Re: trigger AFTER INSERT