"Tom Lane" <[EMAIL PROTECTED]> writes: > I don't think you've thought of quite all of the failure cases. One > that's a bit pressing is that a deadlock isn't necessarily confined to > objects in your own database.
We could do the syscache lookups for only the object we're waiting on and store that information in the lock table for others to refer to. We would have to do the syscache lookup either always or at the point where we first decide we have to block. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster