Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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?
I was unclear on that. RESET sets it back to the postgresql.conf value, right? Do we know that the session didn't change it earlier in the script? That's where it gets tricky. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
