Postgres Pro
Downloads
Home   >   mailing lists

Re: trigger AFTER INSERT - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: trigger AFTER INSERT
Date
Msg-id 4C69236F020000250003469A@gw.wicourts.gov
Whole thread Raw
In response to Re: trigger AFTER INSERT  ("Josi Perez (3T Systems)" <josiperez3t@gmail.com>)
List pgsql-admin
Tree view 
"Josi Perez (3T Systems)" <josiperez3t@gmail.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

pgsql-admin by date:

Previous
From: "Josi Perez (3T Systems)"
Date:
Subject: Re: trigger AFTER INSERT
Next
From: Peter Koczan
Date:
Subject: Is regular vacuuming with autovacuum needed?