MIME-Version: 1.0
References: <165400680669.573549.5553646427767597793@wrigleys.postgresql.org>
 <CAKFQuwYyQaDsBRjKGn2ewqLDdMcTJbdLF6-fH2z3zrpRv61t-g@mail.gmail.com>
 <184838.1654011177@sss.pgh.pa.us>
In-Reply-To: <184838.1654011177@sss.pgh.pa.us>
From: Gustavo <gustavomilc@gmail.com>
Date: Tue, 31 May 2022 13:58:24 -0300
Message-ID: 
 <CAKyyQ7foAp2hKGXiN6RpfqSweiPJAJDm+cAQnFKnhyTFbnznTg@mail.gmail.com>
Subject: Re: CREATE EXTENSION not adding extension on second SCHEMA
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e965ba05e051ae76"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKyyQ7foAp2hKGXiN6RpfqSweiPJAJDm%2BcAQnFKnhyTFbnznTg%40mail.gmail.com>
Precedence: bulk

--000000000000e965ba05e051ae76
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you so much guys, my mistake I didn't pay attention. I'm new
to PostgreSQL and your help is much appreciated!


Em ter., 31 de mai. de 2022 =C3=A0s 12:32, Tom Lane <tgl@sss.pgh.pa.us> esc=
reveu:

> "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 =
does work.  I
> really
> > don=E2=80=99t see a need to say you cannot install the same extension m=
ultiple
> > 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
>

--000000000000e965ba05e051ae76
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Thank you so much guys, my mistake I didn=
&#39;t pay attention. I&#39;m new to=C2=A0PostgreSQL and your help is much =
appreciated!<br><br><br></div><br><div class=3D"gmail_quote"><div dir=3D"lt=
r" class=3D"gmail_attr">Em ter., 31 de mai. de 2022 =C3=A0s 12:32, Tom Lane=
 &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; escreve=
u:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">&quot;David G=
. Johnston&quot; &lt;<a href=3D"mailto:david.g.johnston@gmail.com" target=
=3D"_blank">david.g.johnston@gmail.com</a>&gt; writes:<br>
&gt; On Tuesday, May 31, 2022, PG Doc comments form &lt;<a href=3D"mailto:n=
oreply@postgresql.org" target=3D"_blank">noreply@postgresql.org</a>&gt;<br>
&gt; wrote:<br>
&gt;&gt; I&#39;m trying to add an extension to two schemas that I have in m=
y DB.<br>
<br>
&gt; It doesn=E2=80=99t work and isn=E2=80=99t documented as something that=
 does work.=C2=A0 I really<br>
&gt; don=E2=80=99t see a need to say you cannot install the same extension =
multiple<br>
&gt; times explicitly - the self-describing error seems sufficient.<br>
<br>
The CREATE EXTENSION reference page says<br>
<br>
&quot;There must not be an extension of the same name already loaded.&quot;=
<br>
<br>
and later<br>
<br>
&quot;Remember that the extension itself is not considered to be within any=
<br>
schema: extensions have unqualified names that must be unique<br>
database-wide. But objects belonging to the extension can be within<br>
schemas.&quot;<br>
<br>
I hardly see how we could make this any plainer.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div></div>

--000000000000e965ba05e051ae76--