Are triggers part of the transaction block that triggered the trigger?

Поиск
Список
Период
Сортировка
От Philip Hallstrom
Тема Are triggers part of the transaction block that triggered the trigger?
Дата
Msg-id Pine.BSF.4.31.0101031023070.17859-100000@oddjob.adhesivemedia.com
обсуждение исходный текст
Ответы Re: Are triggers part of the transaction block that triggered the trigger?
Список pgsql-general
Hi all -
    Are triggers part of the transaction block that triggered the
trigger?  I mean if I have a trigger that updates (an insert) a table (say
for logging or whatever) and that insert fails will the original query the
fired the trigger also get rolled back?

I'm using 7.0.3.

Thanks!

-philip




В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Davis
Дата:
Сообщение: Numeric and money
Следующее
От: "Francis Solomon"
Дата:
Сообщение: RE: [SQL] Numeric and money