Re: [HACKERS] Statement-level rollback

2018-06-18 Thread Robert Haas
On Mon, Jun 18, 2018 at 4:51 PM, Alvaro Herrera wrote: > On 2018-Jun-16, Robert Haas wrote: >> I'm not sure that really solves the problem, because changing the GUC >> in either direction causes the system to behave differently. I don't >> see any particular reason to believe that changing the be

Re: [HACKERS] Statement-level rollback

2018-06-18 Thread Alvaro Herrera
On 2018-Jun-16, Robert Haas wrote: > I'm not sure that really solves the problem, because changing the GUC > in either direction causes the system to behave differently. I don't > see any particular reason to believe that changing the behavior from A > to B is any more or less likely to break app

Re: [HACKERS] Statement-level rollback

2018-06-16 Thread Simon Riggs
On 15 June 2018 at 21:23, Alvaro Herrera wrote: > I think the main objectionable point is that of making servers behave in > a way that could lose data, if applications assume that transactions > behave in the way they do today. I propose that we solve this by > allowing this feature to be enabl

Re: [HACKERS] Statement-level rollback

2018-06-15 Thread Robert Haas
On Fri, Jun 15, 2018 at 4:23 PM, Alvaro Herrera wrote: > I've been looking at re-implementing this feature recently, using > Tsunakawa's proposed UI of a GUC transaction_rollback_scope that can > take values "transaction" (default, current behavior) and "statement". > I didn't take other parts of

Re: [HACKERS] Statement-level rollback

2018-06-15 Thread MauMau
From: Alvaro Herrera > I've been looking at re-implementing this feature recently, using > Tsunakawa's proposed UI of a GUC transaction_rollback_scope that can > take values "transaction" (default, current behavior) and "statement". > I didn't take other parts of his patch though; see below. Thank

Re: [HACKERS] Statement-level rollback

2018-06-15 Thread Alvaro Herrera
On 2017-Nov-06, Tsunakawa, Takayuki wrote: > From: Simon Riggs > > A backend-based solution is required for PL procedures and functions. > > > > We could put this as an option into PL/pgSQL, but it seems like it is > > a function of the transaction manager rather than the driver. > > Exactly. T

Re: [HACKERS] Statement-level rollback

2018-03-01 Thread Andres Freund
Hi, On 2018-01-09 08:21:33 +, Tsunakawa, Takayuki wrote: > From: Simon Riggs [mailto:si...@2ndquadrant.com] > > When will the next version be posted? > > I'm very sorry I haven't submitted anything. I'd like to address this during > this CF. Thanks for remembering this. Given that no new

RE: [HACKERS] Statement-level rollback

2018-01-09 Thread Tsunakawa, Takayuki
From: Simon Riggs [mailto:si...@2ndquadrant.com] > When will the next version be posted? I'm very sorry I haven't submitted anything. I'd like to address this during this CF. Thanks for remembering this. Regards Takayuki Tsunakawa

Re: [HACKERS] Statement-level rollback

2018-01-07 Thread Simon Riggs
On 6 November 2017 at 12:36, MauMau wrote: > when I submit the next revision of my patch. When will the next version be posted? -- Simon Riggshttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: [HACKERS] Statement-level rollback

2017-11-28 Thread Michael Paquier
On Mon, Nov 6, 2017 at 9:36 PM, MauMau wrote: > From: Thomas Munro > With your v2 patch "make docs" fails. Here is a small patch to apply > on top of yours to fix that and some small copy/paste errors, if I > understood correctly. > > Ouch, thanks. I'd like to merge your fix when I submit the ne