From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: "gustavomilc@gmail.com" <gustavomilc@gmail.com>,
        "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Subject: Re: CREATE EXTENSION not adding extension on second SCHEMA
In-reply-to: 
 <CAKFQuwYyQaDsBRjKGn2ewqLDdMcTJbdLF6-fH2z3zrpRv61t-g@mail.gmail.com>
References: <165400680669.573549.5553646427767597793@wrigleys.postgresql.org>
 <CAKFQuwYyQaDsBRjKGn2ewqLDdMcTJbdLF6-fH2z3zrpRv61t-g@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Tue, 31 May 2022 08:24:33 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <184837.1654011177.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 31 May 2022 11:32:57 -0400
Message-ID: <184838.1654011177@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/184838.1654011177%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tuesday, May 31, 2022, PG Doc comments form <noreply@postgresql.org>
> wrote:
>> I'm trying to add an extension to two schemas that I have in my DB.

> It doesn=E2=80=99t work and isn=E2=80=99t documented as something that d=
oes work.  I really
> don=E2=80=99t see a need to say you cannot install the same extension mu=
ltiple
> times explicitly - the self-describing error seems sufficient.

The CREATE EXTENSION reference page says

"There must not be an extension of the same name already loaded."

and later

"Remember that the extension itself is not considered to be within any
schema: extensions have unqualified names that must be unique
database-wide. But objects belonging to the extension can be within
schemas."

I hardly see how we could make this any plainer.

			regards, tom lane