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

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