Triggers and Transactions

From: "Chris Coleman" <chris(at)karumbo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Triggers and Transactions
Date: 2006-04-20 16:25:45
Message-ID: 430914310604200925y2a42788co27aa748c6ac84c0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fernan Aguero 2006-04-20 16:52:38 Re: grant privileges across schemas
Previous Message Martijn van Oosterhout 2006-04-20 15:29:48 Re: HUGE Stack space is gettiing consumed