Re: (FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: (FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions
Date
Msg-id 20060830010220.GA23482@winnie.fuhr.org
Whole thread Raw
In response to (FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-novice
On Tue, Aug 29, 2006 at 04:14:49PM -0700, Richard Broersma Jr wrote:
> In PostgreSQL, is it possible for a trigger function called by a
> STATEMENT LEVEL AFTER {any} TRIGGER to roll back or commit an
> implied transaction of a single SQL Statement?

An AFTER trigger can raise an exception to abort the operation.

--
Michael Fuhr

pgsql-novice by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Difference between char and varchar
Next
From: "Jasbinder Bali"
Date:
Subject: Version 1 Calling convention