Skip site navigation (1) Skip section navigation (2)

Re: CREATE EXTENSION BLOCKS

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>,"pgsql-hackers(at)postgresql(dot)org Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CREATE EXTENSION BLOCKS
Date: 2013-04-03 18:41:05
Message-ID: 20130403184104.GJ5117@eldon.alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
David E. Wheeler wrote:
> On Apr 3, 2013, at 2:37 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> 
> > I'd expect one of the CREATE EXTENSION commands to succeed
> > and the others to block until the transaction is committed,
> > then to fail with 'extension "oracle_fdw" already exists'.
> > 
> > If that is what happens, it's what I'd expect since
> > extension names are unique (see the unique constraint on
> > pg_extension).
> 
> Oh, they are not unique per-schema? I guess they are global to the database but then their objects are in the specified schema, then.

Right -- an extension is not considered to live within a schema, they
are database-global.  The objects might live in a particular schema (if
it is "relocatable"), and there's support to move those to a different
schema, but this doesn't affect the extension itself.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


In response to

Responses

pgsql-hackers by date

Next:From: Gavin FlowerDate: 2013-04-03 18:42:36
Subject: Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)
Previous:From: Tom LaneDate: 2013-04-03 18:39:39
Subject: Re: c language functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group