Re: Transaction aborts on syntax error.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Transaction aborts on syntax error.
Дата
Msg-id 4532.1076707905@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Transaction aborts on syntax error.  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
Список pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
>> which might not be for every statement.  Savepoints that you don't
>> actually need are going to be a fairly expensive overhead, AFAICS.

> Well with other db's per statement rollback is a no overhead feature, 
> so this is pg specific.

I very much doubt that.  We are not expending any disk I/O to do
rollback, which is not true in (say) Oracle.  I'm concerned about the
internal bookkeeping overhead.
        regards, tom lane


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Transaction aborts on syntax error.
Следующее
От: Joseph Tate
Дата:
Сообщение: Re: pg_restore problems and suggested resolution