On Fri, Aug 25, 2006 at 08:02:21PM -0500, Jim C. Nasby wrote: > On Fri, Aug 25, 2006 at 06:57:58PM +0100, Gregory Stark wrote: > > I'll use this opportunity to plug that feature again. I think most > > people should use autocommit off with on_error_rollack on for most > > of their daily use. Being able to double check the results of my > > ad-hoc updates before committing them saved me more headaches than > > I can count with Oracle. Autocommit off only became practical for > > interactive use with postgres when savepoints showed up. > > +1
+1 here, too :) Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend