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



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to