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