Re: Prevent concurrent DROP SCHEMA when certain objects are beinginitially created in the namespace - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Prevent concurrent DROP SCHEMA when certain objects are beinginitially created in the namespace
Date
Msg-id 20180906185627.GM2726@paquier.xyz
Whole thread Raw
In response to Re: Prevent concurrent DROP SCHEMA when certain objects are beinginitially created in the namespace  (Jimmy Yih <jyih@pivotal.io>)
List pgsql-hackers
On Wed, Sep 05, 2018 at 12:14:41AM -0700, Jimmy Yih wrote:
> Attached the isolation spec file.  I originally was only going to fix the
> simple CREATE TYPE scenario but decided to look up other objects that can
> reside in namespaces and ended up finding a handful of others.  I tested
> each one manually before and after adding the AccessShareLock acquire on
> the schema.

(You should avoid top-posting, this is not the style of the lists.)

Thanks.  One problem I have with what you have here is that you just
test only locking path as the session dropping the session would just
block on the first concurrent object it finds.  If you don't mind I am
just stealing it, and extending it a bit ;)
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: James Coleman
Date:
Subject: Re: [PATCH] Incremental sort (was: PoC: Partial sort)
Next
From: Peter Eisentraut
Date:
Subject: Re: Collation versioning