SET PATH / DROP SCHEMA lock conflict

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема SET PATH / DROP SCHEMA lock conflict
Дата
Msg-id 701A757D-DF08-472B-9826-B003CB4E5D10@thebuild.com
обсуждение исходный текст
Список pgsql-general
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



В списке pgsql-general по дате отправления: