Thread: SET PATH / DROP SCHEMA lock conflict

SET PATH / DROP SCHEMA lock conflict

From
Christophe Pettus
Date:
Is there a potential lock conflict between SET PATH and DROP SCHEMA?  I've observed (second-hand, so I haven't been
ableto check pg_locks) sessions piling up on a SET PATH while a DROP SCHEMA ... CASCADE is taking a long time to
completedue to a large number of tables in the schema. 

Best,
--
-- Christophe Pettus
   xof@thebuild.com