Re: autocommit vs TRUNCATE et al

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: autocommit vs TRUNCATE et al
Дата
Msg-id 10270.1035240397@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: autocommit vs TRUNCATE et al  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: autocommit vs TRUNCATE et al  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>>> Maybe we can throw a WARNING when autocommit is on.  Would that make
>>> everyone happy?
>> 
>> I doubt it, because by the time you read the WARNING it's too late:
>> the statement's already committed.

> I assume the same limitation would hold for VACUUM, right, that you have
> to turn on autocommit mode to use it?

Yeah, it would, unless we wanted to throw in some additional hack to
distinguish VACUUM from the "more dangerous" cases.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: autocommit vs TRUNCATE et al
Следующее
От: Justin Clift
Дата:
Сообщение: German version of the PostgreSQL "Advocacy and Marketing" site is ready