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.a...@wien.gv.at> wrote: > Andreas Kretschmer wrote: > >> Alexander Farber <alexander.far...@gmail.com> 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. >
