Triggers and Transactions

Поиск
Список
Период
Сортировка
От Chris Coleman
Тема Triggers and Transactions
Дата
Msg-id 430914310604200925y2a42788co27aa748c6ac84c0@mail.gmail.com
обсуждение исходный текст
Ответы Re: Triggers and Transactions  (Terry Lee Tucker <terry@esc1.com>)
Список 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 по дате отправления:

Предыдущее
От: "news.postgresql.org"
Дата:
Сообщение: Notification EXTRA data
Следующее
От: sconeek@gmail.com
Дата:
Сообщение: Re: temp tables problem