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
