Postgres Pro
Downloads
Home   >   mailing lists

SET PATH / DROP SCHEMA lock conflict - Mailing list pgsql-general

From Christophe Pettus
Subject SET PATH / DROP SCHEMA lock conflict
Date
Msg-id 701A757D-DF08-472B-9826-B003CB4E5D10@thebuild.com
Whole thread Raw
List pgsql-general
Tree view 
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 by date:

Previous
From: Craig Ringer
Date:
Subject: Re: role does not exist
Next
From: zhangbonian
Date:
Subject: can a partition be loaded from file?