Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive
Date
Msg-id CAFj8pRDBwQPhr5GHT_eo-3n-WiQGp99iDZ-QA17RtEOm1LPP4g@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive
List pgsql-hackers


2017-03-15 16:38 GMT+01:00 Robert Haas <robertmhaas@gmail.com>:
On Wed, Mar 15, 2017 at 2:29 AM, Peter van Hardenberg <pvh@pvh.ca> wrote:
> Ads and I were talking over breakfast about usability issues and he
> mentioned transaction cancellation during interactive sessions as a serious
> pain point.
>
> I suggest we update the default of ON_ERROR_ROLLBACK to interactive for
> 10.0.
>
> The last discussion I could find about this subject was in 2011 and while
> there was concern about setting the default to "on" (as this would tamper
> with the expected behaviour of scripts), I don't see any identification of a
> problem that would be caused by setting it to "interactive" by default.

Well, then you'd get one behavior when you use psql interactively, and
another behavior when you use it from a script.  And if you used a
client other than psql the behavior would be different from psql.
Plus, it's kinda surprising to have a client that, by default, is
sending secret commands to the server that you don't know about.  And
it's a backward-incompatible change against previous releases.  I
don't think any of that makes this the worst idea ever, but on balance
I still think it's better to just recommend to people that they
configure their .psqlrc with this setting if they want the behavior.

In short, -1 from me.

I agree with Robert. I prefer some doc, web page "after install steps". 

Pavel
 

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: [HACKERS] Backend crash on non-exclusive backup cancel
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] Backend crash on non-exclusive backup cancel