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

Re: CREATE EXTENSION BLOCKS

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: "pgsql-hackers(at)postgresql(dot)org Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CREATE EXTENSION BLOCKS
Date: 2013-04-03 16:01:15
Message-ID: 1549E73B-8ABA-44BF-987F-2D685FF8F9D3@justatheory.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

Thanks,

David



In response to

Responses

pgsql-hackers by date

Next:From: Gavin FlowerDate: 2013-04-03 16:09:01
Subject: Re: [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)
Previous:From: Tom LaneDate: 2013-04-03 16:00:02
Subject: track_activities is mostly broken

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