Re: PL/pgSQL: EXCEPTION NOSAVEPOINT - Mailing list pgsql-patches

From Matt Miller
Subject Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
Date
Msg-id 1123101150.3385.51.camel@dbamm01-linux
Whole thread Raw
In response to Re: PL/pgSQL: EXCEPTION NOSAVEPOINT  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
List pgsql-patches
On Wed, 2005-08-03 at 16:25 -0400, Tom Lane wrote:
> > The idea is to allow a PL/pgSQL exception to not automatically
> > rollback the work done by the current block.
>
> This fundamentally breaks the entire backend.

Yeah, but besides that, can you quick commit this to HEAD so I don't
have to keep track of it locally?

Just kidding.

> You do not have the
> option to continue processing after elog(ERROR); the (sub)transaction
> rollback is necessary to clean up inconsistent state.

Okay, I'll look at this more closely.  Can you give me an example of
what can go wrong?

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
Next
From: Tom Lane
Date:
Subject: Re: PL/pgSQL: EXCEPTION NOSAVEPOINT