Skip site navigation (1) Skip section navigation (2)

Re: Nested xacts: looking for testers and review

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: alvherre(at)dcc(dot)uchile(dot)cl
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Nested xacts: looking for testers and review
Date: 2004-05-28 15:27:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Can I ask you one more question?

Is there any limit for nesting leveles of subtransactions?
Tatsuo Ishii

> 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.
> 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.
> -- 
> Alvaro Herrera (<alvherre[a]>)
> "Limítate a mirar... y algun día veras"
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to


pgsql-hackers by date

Next:From: Sailesh KrishnamurthyDate: 2004-05-28 15:36:36
Subject: Re: On query rewrite
Previous:From: Marc G. FournierDate: 2004-05-28 15:27:35
Subject: Re: Win32, PITR, nested transactions, tablespaces

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group