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]dcc.uchile.cl>)
> "Lim�tate a mirar... y algun d�a veras"
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
