"Pavan Deolasee" <[EMAIL PROTECTED]> writes: > Alternatively, we can just acquire AccessExclusiveLock on the main relation > before proceeding with the recursive deletion. That would solve this case, > but may be there are other similar deadlocks waiting to happen.
Surely we should be locking the relation before even doing the dependency scan or else someone else can come along and add more dependencies after we've started the scan? > Also I am not sure if the issue is big enough to demand the change. I think it is, effectively what we have now is "your DDL could fail randomly for reasons that are out of your control" :( -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
