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

From Tom Lane
Subject Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
Date
Msg-id 3738.1123100730@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL: EXCEPTION NOSAVEPOINT  (Matt Miller <mattm@epx.com>)
Responses Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
List pgsql-patches
Matt Miller <mattm@epx.com> writes:
> 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.  You do not have the
option to continue processing after elog(ERROR); the (sub)transaction
rollback is necessary to clean up inconsistent state.

            regards, tom lane

pgsql-patches by date:

Previous
From: Matt Miller
Date:
Subject: PL/pgSQL: EXCEPTION NOSAVEPOINT
Next
From: Matt Miller
Date:
Subject: Re: PL/pgSQL: EXCEPTION NOSAVEPOINT