Re: autocommit vs TRUNCATE et al

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