Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 29 Aug 2006 19:02:20 -0600
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
- References:
- (FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions
- From: Richard Broersma Jr
- (FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions
- Prev by Date: Re: Difference between char and varchar
- Next by Date: Version 1 Calling convention
- Previous by thread: (FOR EACH STATEMENT AFTER UPDATE) Triggers & Transactions
- Next by thread: Version 1 Calling convention
- Indexes: