Re: [PATCHES] Continue transactions after errors in psql - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: [PATCHES] Continue transactions after errors in psql
Date
Msg-id 426DD79A.10808@paradise.net.nz
Whole thread Raw
In response to Re: [PATCHES] Continue transactions after errors in psql  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian wrote:
> Mark Kirkwood wrote:
> 
>
>>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. 

Sweet.

> The fact that
> interactive and non-interactive behavior is different is something that
> suggests that turning it on by default might cause confusion.
> 

True, but reasonably explained by suggesting that non-interactive 
scripts should not be expected to keep going when there are typos or 
similar. In fact, I seem to recall being burned by that very thing in my 
early Oracle days...

Mark


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: simplify register_dirty_segment()
Next
From: Tom Lane
Date:
Subject: Re: DO INSTEAD and conditional rules