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

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: 'Andreas Kretschmer' <andreas(at)a-kretschmer(dot)de>, Alexander Farber <alexander(dot)farber(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Does RAISE EXCEPTION rollback previous commands in a stored function?
Date: 2016-03-02 09:37:22
Message-ID: A737B7A37273E048B164557ADEF4A58B53805A26@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas Kretschmer wrote:
>> Alexander Farber <alexander(dot)farber(at)gmail(dot)com> hat am 1. März 2016 um 19:41
>> geschrieben:
>>
>>
>> Good evening,
>>
>> 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.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message schoetbi schoetbi 2016-03-02 09:42:21 pg_upgrade 9.5.1: pg_upgrade_support missing
Previous Message John R Pierce 2016-03-02 08:39:28 Re: could not migrate 8.0.13 database with large object data to 9.5.1