Re: Transaction Handling in pl/pgsql

Поиск
Список
Период
Сортировка
От Douglas McNaught
Тема Re: Transaction Handling in pl/pgsql
Дата
Msg-id m2hdezvp51.fsf@Douglas-McNaughts-Powerbook.local
обсуждение исходный текст
Ответ на Re: Transaction Handling in pl/pgsql  ("Craig Bryden" <postgresql@bryden.co.za>)
Список pgsql-general
"Craig Bryden" <postgresql@bryden.co.za> writes:

> OK. I have read that. The part that sticks out is "A block containing an
> EXCEPTION clause is significantly more expensive to enter and exit than a
> block without one. Therefore, don't use EXCEPTION without need. ".
> Performance is paramount to me.
>
> If I ommit the EXCEPTION clause will all the statements still be rolled back
> if an error occurs?

Yes, if you don't use EXCEPTION clauses the behavior is the same as
previous versions.

-Doug

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

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Transaction Handling in pl/pgsql
Следующее
От: "Craig Bryden"
Дата:
Сообщение: Re: Transaction Handling in pl/pgsql