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
pgsql-hackers by date
|Next:||From: Gavin Flower||Date: 2013-04-03 18:42:36|
|Subject: Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re:
Should array_length() Return NULL)|
|Previous:||From: Tom Lane||Date: 2013-04-03 18:39:39|
|Subject: Re: c language functions|