Re: CREATE EXTENSION BLOCKS - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: CREATE EXTENSION BLOCKS
Date
Msg-id 1549E73B-8ABA-44BF-987F-2D685FF8F9D3@justatheory.com
Whole thread Raw
In response to Re: CREATE EXTENSION BLOCKS  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: CREATE EXTENSION BLOCKS
List pgsql-hackers
On Apr 3, 2013, at 2:37 AM, Albe Laurenz <laurenz.albe@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. 

Thanks,

David




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: track_activities is mostly broken
Next
From: Gavin Flower
Date:
Subject: Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)