Re: Trigger - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Trigger
Date
Msg-id Pine.LNX.4.44.0310230042260.8099-100000@peter.localdomain
Whole thread Raw
In response to Re: Trigger  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
scott.marlowe writes:

> A trigger inside a transaction should automagically roll back should the
> transaction fail, shouldn't it?

The database actions that the trigger possibly executed are rolled back
just like any other database actions.  But if your trigger does something
external to the database, you have a problem (that borders on
unsolvable).

--
Peter Eisentraut   peter_e@gmx.net


pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: ANNOUNCE: Bricolage 1.6.7
Next
From: jearl@bullysports.com
Date:
Subject: Re: database files