Re: [PATCHES] Continue transactions after errors in psql

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Mark Kirkwood <markir@paradise.net.nz>
Cc: Greg Sabino Mullane <greg@turnstep.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2005-04-26T03:23:53Z
Lists: pgsql-hackers
Mark Kirkwood wrote:
> Bruce Momjian wrote:
> > 
> > 	disable it by default for all sessions (current patch)
> > 	enable it by default only for interactive sessions, like AUTOCOMMIT
> 
> These two seem like the best contenders.
> 
> The choice comes down to whether we should:
> 
> 1) Be like most other dbms's (e.g. Oracle, Firebird) + follow the spec.
> 2) Minimize psql behavior changes for current postgresql users.
> 
> Personally I favor 1), so would prefer:
> 
> enable it by default only for interactive sessions, like AUTOCOMMIT

We are going for 'off' by default and only interactive.  The fact that
interactive and non-interactive behavior is different is something that
suggests that turning it on by default might cause confusion.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073