Postgres Pro
Downloads
Home   >   mailing lists

Re: Information on savepoint requirement within transctions - Mailing list pgsql-general

From David G. Johnston
Subject Re: Information on savepoint requirement within transctions
Date
Msg-id CAKFQuwaa6iSKFN6EG3vX-+KiX-4Ybc5-e7y_cxt4Ji9GUTTbGg@mail.gmail.com
Whole thread Raw
In response to Re: Information on savepoint requirement within transctions  (Robert Zenz <robert.zenz@sibvisions.com>)
Responses Re: Information on savepoint requirement within transctions
List pgsql-general
Tree view
On Fri, Jan 26, 2018 at 8:57 AM, Robert Zenz <robert.zenz@sibvisions.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.
​
 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Information on savepoint requirement within transctions
Next
From: Melvin Davidson
Date:
Subject: Re: Information on savepoint requirement within transctions