Re: CREATE EXTENSION BLOCKS

On Apr 3, 2013, at 11:41 AM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:

>> Oh, they are not unique per-schema? I guess they are global to the database but then their objects are in the
specifiedschema, 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.

Thanks. I humbly submit this patch to help prevent silly questions like this in the future.

diff --git a/doc/src/sgml/ref/create_extension.sgml b/doc/src/sgml/ref/create_extension.sgml
index 4f3b9a5..4ab3dff 100644
--- a/doc/src/sgml/ref/create_extension.sgml
+++ b/doc/src/sgml/ref/create_extension.sgml
@@ -93,6 +93,8 @@ CREATE EXTENSION [ IF NOT EXISTS ] <replaceable class="parameter">extension_name        relocated.
Thenamed schema must already exist.        If not specified, and the extension's control file does not specify a
schemaeither, the current default object creation schema is used. 
+        Note that only the extension objects will be placed into the named
+        schema; the extension itself is a database-global object.       </para>      </listitem>     </varlistentry>

Best,

David