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

From: Philip Hallstrom <philip(at)adhesivemedia(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Are triggers part of the transaction block that triggered the trigger?
Date: 2001-01-03 18:28:56
Message-ID: Pine.BSF.4.31.0101031023070.17859-100000@oddjob.adhesivemedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Kelley 2001-01-03 18:41:46 Re: Numeric and money
Previous Message Gary Wesley 2001-01-03 18:21:30 Loading optimization