Re: COMMIT after an ERROR? - Mailing list pgsql-general

From Doug McNaught
Subject Re: COMMIT after an ERROR?
Date
Msg-id m3adywzlp8.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to COMMIT after an ERROR?  (J C Lawrence <claw@kanga.nu>)
List pgsql-general
J C Lawrence <claw@kanga.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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: COMMIT after an ERROR?
Next
From: Stephan Szabo
Date:
Subject: Re: Vacuum analyze with 7 millions records ... takes 1