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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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