Triggers and Transactions - Mailing list pgsql-general

From Chris Coleman
Subject Triggers and Transactions
Date
Msg-id 430914310604200925y2a42788co27aa748c6ac84c0@mail.gmail.com
Whole thread Raw
Responses Re: Triggers and Transactions  (Terry Lee Tucker <terry@esc1.com>)
List pgsql-general
Hi,

I have a question about how much of a trigger is in a transaction.
I've read the docs and googled around but can't seem to find a
concrete answer.

I have two triggers that are designed to work together, one is a
before trigger and one is an after.  If the before trigger succeeds
then it will have made some changes to one of my tables, however if
the after one fails some how (elog(ERROR, "")? then I would like to
rollback the changes of the before one as well as any made by the
after one too.

Is this possible?

Many thanks

Chris Coleman.

pgsql-general by date:

Previous
From: "news.postgresql.org"
Date:
Subject: Notification EXTRA data
Next
From: sconeek@gmail.com
Date:
Subject: Re: temp tables problem