"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> I sort of expected the release of the savepoint to be tantamount to a
> commit of the subtransaction, but it doesn't appear to have been.
But you still haven't committed the outer transaction: rolling it back
must undo the effects of the subtransaction, no? So a "release" merely
destroys the separate identity of the subtransaction and assigns all its
effects (including locks) to the parent transaction.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
