Re: autocommit vs TRUNCATE et al

Bruce Momjian  writes:
> One particularly nasty problem is issuing a VACUUM or TRUNCATE in cases
> where you don't know the autocommit mode.  You could set autocommit to
> 'on', and issue the command, but how do you know if you need to turn
> autocommit back off again?

Perhaps RESET AUTOCOMMIT is a good enough answer?
		regards, tom lane