Re: Information on savepoint requirement within transctions

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Information on savepoint requirement within transctions
Дата
Msg-id CAKFQuwaa6iSKFN6EG3vX-+KiX-4Ybc5-e7y_cxt4Ji9GUTTbGg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Information on savepoint requirement within transctions  (Robert Zenz <robert.zenz@sibvisions.com>)
Ответы Re: Information on savepoint requirement within transctions  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Information on savepoint requirement within transctions
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Information on savepoint requirement within transctions