Re: Functions, savepoints, autocommit = I am confused ! - Mailing list pgsql-general

From Tim Smith
Subject Re: Functions, savepoints, autocommit = I am confused !
Date
Msg-id CA+HuS5GR6QzhUa2YGz3GyQzWN8W84jLU+ub=1Yvc3Tz06jpLLw@mail.gmail.com
Whole thread Raw
In response to Re: Functions, savepoints, autocommit = I am confused !  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
> You need to trap exceptions and in the handler block issue a
>
> ROLLBACK TO SAVEPOINT
>
> http://www.postgresql.org/docs/9.4/static/sql-rollback-to.html
>
>
> otherwise the the ROLLBACK issued at pg-session end will simply rollback
> everything.
>
> David J.
>

Thanks, will take a look.


pgsql-general by date:

Previous
From: Tim Smith
Date:
Subject: Re: Functions, savepoints, autocommit = I am confused !
Next
From: Tim Smith
Date:
Subject: Re: Functions, savepoints, autocommit = I am confused !