David E. Wheeler wrote: > On Apr 3, 2013, at 2:37 AM, Albe Laurenz <laurenz.a...@wien.gv.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers