Re: Transactions within a function body - Mailing list pgsql-general

From Tom Lane
Subject Re: Transactions within a function body
Date
Msg-id 1510.1222961293@sss.pgh.pa.us
Whole thread Raw
In response to Re: Transactions within a function body  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Reg Me Please escribi�:
>> You mean I can issue a ROLLBACK command within a BEGIN...END; block to roll it
>> back?

> No -- I mean you can use BEGIN/EXCEPTION/END blocks as you like, nesting
> them or putting one after another.  Complementing this with RAISE
> EXCEPTION you can cause savepoints to roll back at will.

Yeah, it's essentially the same functionality as savepoints, but
different syntax.

            regards, tom lane

pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: Re: Transactions within a function body
Next
From: "Bob Henkel"
Date:
Subject: Re: Transactions within a function body