Skip site navigation (1) Skip section navigation (2)

Re: (FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: Novice Postgresql-list <pgsql-novice(at)postgresql(dot)org>
Subject: Re: (FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions
Date: 2006-08-30 01:02:20
Message-ID: 20060830010220.GA23482@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-novice by date

Next:From: Jasbinder BaliDate: 2006-08-30 04:25:28
Subject: Version 1 Calling convention
Previous:From: Bruce MomjianDate: 2006-08-29 23:42:16
Subject: Re: Difference between char and varchar

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group