Re: Information on savepoint requirement within transctions

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Robert Zenz <robert(dot)zenz(at)sibvisions(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Information on savepoint requirement within transctions
Date: 2018-01-26 16:12:39
Message-ID: CAKFQuwaa6iSKFN6EG3vX-+KiX-4Ybc5-e7y_cxt4Ji9GUTTbGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 26, 2018 at 8:57 AM, Robert Zenz <robert(dot)zenz(at)sibvisions(dot)com>
wrote:

> In PostgreSQL the use of savepoints is
> required:
>
> start transaction
> insert into A
> create savepoint
> insert into B but fail
> rollback to savepoint
> insert into C
> commit
>
> Otherwise the transaction is, after the failed statement, in a state in
> which it
> can not be used anymore. Is that correct?

​Yes.

David J.
​

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2018-01-26 16:27:21 Re: Information on savepoint requirement within transctions
Previous Message David G. Johnston 2018-01-26 16:11:06 Re: Information on savepoint requirement within transctions