Re: COMMIT after an ERROR?

From: Doug McNaught <doug(at)wireboard(dot)com>
To: J C Lawrence <claw(at)kanga(dot)nu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COMMIT after an ERROR?
Date: 2001-10-12 19:45:39
Message-ID: m3adywzlp8.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

J C Lawrence <claw(at)kanga(dot)nu> writes:

> Does an error during a transaction invalidate the transaction?

Yes, the transaction goes into ABORTED state and nothing after the
error will succeed.

> Translation: Do I need to monitor for error conditions during a
> transaction and manually do the ROLLBACK in those cases?

Yup.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-10-12 19:47:55 Re: Index Scans Oddness
Previous Message Vivek Khera 2001-10-12 19:37:23 what's going on with this list?