Re: Shouldn't psql -1 imply ON_ERROR_STOP?

On Sat, Jul 25, 2009 at 9:06 AM, Magnus Hagander<magnus(at)hagander(dot)net> wrote:
> On Saturday, July 25, 2009, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
>> When you run a file with psql -1/--single-transaction, and a command fails,
>> you get bombarded with
>>
>> ERROR:  current transaction is aborted, commands ignored until end of
>> transaction block
>>
>> for the rest of the file.
>>
>
> That would certainly be useful.
>
> Personally I'd prefer it to default to that always, and not just in
> -1, but that would break way too many old things I'm afraid...

Doing it always would be really annoying. I often reload dumps that
fail the grant statements but otherwise work. Admittedly, if I
planned ahead, I could avoid having the grants be present in the
dumps, but that would require planning ahead...

But +1 for doing it when -1 is used.

...Robert