Re: SAVEPOINT and FOR UPDATE

"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