"Thomas F. O'Connell" <tfo@xxxxxxxxxxxx> 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
