Re: Does RAISE EXCEPTION rollback previous commands in a stored function?

[Alexander Farber <alexander.farber@xxxxxxxxx>]

Hi Laurenz,

how to set such a savepoint inside of a stored function?

Can I call "START TRANSACTION", and then at some point later in the same stored function call RAISE EXCEPTION?

Regargs

Alex

On Wed, Mar 2, 2016 at 10:37 AM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:

Andreas Kretschmer wrote:
>> Alexander Farber <alexander.farber@xxxxxxxxx> hat am 1. März 2016 um 19:41
>> geschrieben:

 

>> in PostgreSQL 9.5 does RAISE EXCEPTION reliably rollback all previous
>> commands in a stored function?
>
> Yes.

That is, unless you set a savepoint to which you can rollback.