Re: CREATE EXTENSION BLOCKS

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