Postgres Pro
Downloads
Home   >   mailing lists

Are triggers part of the transaction block that triggered the trigger? - Mailing list pgsql-general

From Philip Hallstrom
Subject Are triggers part of the transaction block that triggered the trigger?
Date
Msg-id Pine.BSF.4.31.0101031023070.17859-100000@oddjob.adhesivemedia.com
Whole thread Raw
Responses Re: Are triggers part of the transaction block that triggered the trigger?  ("Robert B. Easter" <reaster@comptechnews.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Michael Davis
Date:
Subject: Numeric and money
Next
From: "Francis Solomon"
Date:
Subject: RE: [SQL] Numeric and money