On Thu, 2006-11-16 at 20:23 -0500, Tom Lane wrote:
> We should treat
> exclusive lock held under any of the current backend's subtransactions
> as not to be overridden.
I can't find any clear discussion of this within the docs. I guess if
there were some clear statements on this it would have been uncovered
earlier.
We should say something like "Once a lock has been taken it will be held
until the end of the transaction. Locks obtained after a SAVEPOINT (i.e.
within a subtransaction) will continue to be held even after a RELEASE
SAVEPOINT". Does this also apply if we do a ROLLBACK TO SAVEPOINT?
I'll do some docs for the Concurrency Control section.
Has the same thinking been applied to table level locks also?
LOCK TABLE has same issue maybe?
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com