Re: Does psql use nested transactions?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Does psql use nested transactions?
Дата
Msg-id 6244.1092764380@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Does psql use nested transactions?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Does psql use nested transactions?  (Gaetano Mendola <mendola@bigfoot.com>)
Re: Does psql use nested transactions?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Added to TODO list:

> * Add an option to automatically use savepoints for each statement in a
>   multi-statement transaction.

>   When enabled, this would allow errors in multi-statement transactions
>   to be automatically ignored.

Note that whoever implements this had better be mindful of the bad
experience we had with autocommit.  If there is any way that this
behavior could be turned on underneath an application/script without
the app knowing about it, this would be spectacularly dangerous.

Like I said, my preference would be that it couldn't be turned on at all
except when psql's input is interactive.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Does psql use nested transactions?
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: Does psql use nested transactions?