Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"
Дата
Msg-id D1837AA1-ADF0-4236-8BEC-08A1357A77AE@thebuild.com
обсуждение исходный текст
Ответ на Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"  (Bryn Llewellyn <bryn@yugabyte.com>)
Список pgsql-general
Дерево обсуждения 

> On Jun 12, 2022, at 23:07, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> The lazy implementation theoretically can be possible, but why?

Isn't one of the reasons for the savepoint (in fact, the principal reason) to reset the connection back to non-error
stateso that execution can continue?  In that case, it really does need to create the savepoint at the start of the
block,regardless of what's in it, since any statement can raise an error.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"
Следующее
От: Joel Rabinovitch
Дата:
Сообщение: Tools to convert timestamp data to another time zone in PostgreSQL