Re: Trigger

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trigger
Date: 2003-10-22 22:43:41
Message-ID: Pine.LNX.4.44.0310230042260.8099-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

  • Re: Trigger at 2003-10-22 19:07:00 from scott.marlowe

Browse pgsql-general by date

  From Date Subject
Next Message jearl 2003-10-22 22:48:34 Re: database files
Previous Message David Wheeler 2003-10-22 22:33:48 ANNOUNCE: Bricolage 1.6.7