Обсуждение: SET PATH / DROP SCHEMA lock conflict

Поиск
Список
Период
Сортировка

SET PATH / DROP SCHEMA lock conflict

От
Christophe Pettus
Дата:
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