Re: Nested xacts: looking for testers and review - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Nested xacts: looking for testers and review
Date
Msg-id 20040529.002518.112627029.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Nested xacts: looking for testers and review  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
> On Fri, May 28, 2004 at 04:51:07PM +0900, Tatsuo Ishii wrote:
> 
> > 2) certain behavior was different from what I expected (please correct me
> >    if my expectation is wrong). 
> 
> Yes, the expected behavior is different: if an aborted subtransaction is
> closed with a COMMIT or END command, the parent transaction is aborted
> too.  This is to inhibit an application which blindly expects the
> subtransaction to succeed to reach an invalid state.  If you want to
> return to non-aborted state, end the subtransaction with ROLLBACK
> instead.

Oh, I got it. Thanks.

> But Bob Henkel and you are right: there needo to be documentation.
> Initially I figured I could do that later because there is no new
> syntax, but it is obviously needed to explain all sorts of assumptions
> and behavior like this.
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: list rewrite committed
Next
From: Tatsuo Ishii
Date:
Subject: Re: Nested xacts: looking for testers and review