Re: deadlock while doing VACUUM and DROP

"Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com> 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!