Horton

Re: [PATCHES] Continue transactions after errors in psql

Mark Kirkwood <markir@paradise.net.nz>

View thread
From: Mark Kirkwood <markir@paradise.net.nz>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Greg Sabino Mullane <greg@turnstep.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2005-04-26T03:08:59Z
Lists: pgsql-hackers 
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

Mark