Re: Connection Pools and DISCARD ALL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Connection Pools and DISCARD ALL
Дата
Msg-id 20312.1191508140@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Connection Pools and DISCARD ALL  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Connection Pools and DISCARD ALL  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> As committed, DISCARD ALL does everything but cannot be issued inside a
> transaction block.

> I'd like to propose that DISCARD ALL also issue a ROLLBACK command if it
> is issued from within a transaction block.

That was *intentional* to prevent mistakes.  Somebody who wants the
above behavior can send "ROLLBACK; DISCARD ALL".
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: First steps with 8.3 and autovacuum launcher
Следующее
От: Tom Lane
Дата:
Сообщение: Re: First steps with 8.3 and autovacuum launcher