Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive

2017-03-16 Thread Andreas 'ads' Scherbaum
On 15.03.2017 16:38, Robert Haas wrote: On Wed, Mar 15, 2017 at 2:29 AM, Peter van Hardenberg 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

Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive

2017-03-15 Thread Joshua Yanovski
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

Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive

2017-03-15 Thread Pavel Stehule
2017-03-15 16:38 GMT+01:00 Robert Haas : > On Wed, Mar 15, 2017 at 2:29 AM, Peter van Hardenberg wrote: > > Ads and I were talking over breakfast about usability issues and he > > mentioned transaction cancellation during interactive sessions as a > serious >

Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive

2017-03-15 Thread Robert Haas
On Wed, Mar 15, 2017 at 2:29 AM, Peter van Hardenberg 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

Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive

2017-03-15 Thread Tom Lane
Peter van Hardenberg writes: > It's quite clear to me that the current default behaviour costs the world > serious pain and heart-ache on a daily basis. This is a large claim for which you've provided little evidence. On the other hand, changing behavior like this from one version

Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive

2017-03-15 Thread Tsunakawa, Takayuki
From: pgsql-hackers-ow...@postgresql.org > [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Peter van > Hardenberg > I suggest we update the default of ON_ERROR_ROLLBACK to interactive for > 10.0. +1 Regards Takayuki Tsunakawa -- Sent via pgsql-hackers mailing list

[HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive

2017-03-15 Thread Peter van Hardenberg
All, 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