Re: transaction error handling - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: transaction error handling
Date
Msg-id CAOR=d=2Wv23iA_i740TLvmapwAxNf3N08xDH-yAmS0H31YhP7w@mail.gmail.com
Whole thread Raw
In response to transaction error handling  (Kasia Tuszynska <ktuszynska@esri.com>)
List pgsql-admin
On Tue, Nov 29, 2011 at 10:57 AM, Kasia Tuszynska <ktuszynska@esri.com> wrote:
> Postgres:
> Begin transaction
> Insert - no error
> Insert - error raised
> Transaction loss = no implicit rollback to the single error free insert.
>
> Is this a correct interpretation of the Postgres transaction error handling?
> If so, are there any changes being considered, or perhaps already implemented?

You can insert a savepoint explicitly if you wish, but without setting
one, then the whole transaction will be rolled back.

pgsql-admin by date:

Previous
From: Kasia Tuszynska
Date:
Subject: Re: transaction error handling
Next
From: Colin E Busse
Date:
Subject: Use a custom postgresql.conf?