Just chiming in: I rely heavily on the current default behavior because it prevents large statements pasted into psql that cause errors in transactions from partially running, and if it were changed I would have caused production outages.
On Wed, Mar 15, 2017 at 8:42 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > > > 2017-03-15 16:38 GMT+01:00 Robert Haas <robertmh...@gmail.com>: >> >> On Wed, Mar 15, 2017 at 2:29 AM, Peter van Hardenberg <p...@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 > > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
