Re: PL/PgSQL: EXIT USING ROLLBACK - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: PL/PgSQL: EXIT USING ROLLBACK
Date
Msg-id 53D3F30E.7020400@joh.to
Whole thread Raw
In response to Re: PL/PgSQL: EXIT USING ROLLBACK  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PL/PgSQL: EXIT USING ROLLBACK  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 7/26/14, 8:22 PM, Tom Lane wrote:
> In particular, what happens if someone attaches USING ROLLBACK
> to an EXIT that does not lead from inside to outside a BEGIN/EXCEPTION
> block?

I'm not sure which case you're envisioning.  A label is required, and 
the label must be that of a BEGIN block with an EXCEPTION block if USING 
ROLLBACK is specified.  If that doesn't answer your question, could try 
and explain (perhaps in the form of an example) which problem you're seeing?


.marko



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/PgSQL: EXIT USING ROLLBACK
Next
From: Marko Tiikkaja
Date:
Subject: PL/PgSQL: RAISE and the number of parameters