MIME-Version: 1.0
In-Reply-To: <165400680669.573549.5553646427767597793@wrigleys.postgresql.org>
References: <165400680669.573549.5553646427767597793@wrigleys.postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 31 May 2022 08:24:33 -0700
Message-ID: 
 <CAKFQuwYyQaDsBRjKGn2ewqLDdMcTJbdLF6-fH2z3zrpRv61t-g@mail.gmail.com>
Subject: Re: CREATE EXTENSION not adding extension on second SCHEMA
To: "gustavomilc@gmail.com" <gustavomilc@gmail.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000aa09a205e0505e58"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwYyQaDsBRjKGn2ewqLDdMcTJbdLF6-fH2z3zrpRv61t-g%40mail.gmail.com>
Precedence: bulk

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

On Tuesday, May 31, 2022, PG Doc comments form <noreply@postgresql.org>
wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/14/sql-createextension.html
> Description:
>
> I'm trying to add an extension to two schemas that I have in my DB.
>
> steps:
>
> 1)
>
> CREATE EXTENSION unaccent with SCHEMA public;
>
> response: OK.
>
> 2)
>
> CREATE EXTENSION unaccent with SCHEMA public_test;
>
> response: SQL Error [42710]: ERROR: extension "unaccent" already exists
>
> I tryed:
>
> SET search_path =3D public_test;
> CREATE EXTENSION unaccent;
>
>  and the response is: response: SQL Error [42710]: ERROR: extension
> "unaccent" already exists
>


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 multi=
ple
times explicitly - the self-describing error seems sufficient.

David J.

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

On Tuesday, May 31, 2022, PG Doc comments form &lt;<a href=3D"mailto:norepl=
y@postgresql.org">noreply@postgresql.org</a>&gt; wrote:<br><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pad=
ding-left:1ex">The following documentation comment has been logged on the w=
ebsite:<br>
<br>
Page: <a href=3D"https://www.postgresql.org/docs/14/sql-createextension.htm=
l" target=3D"_blank">https://www.postgresql.org/<wbr>docs/14/sql-createexte=
nsion.<wbr>html</a><br>
Description:<br>
<br>
I&#39;m trying to add an extension to two schemas that I have in my DB.<br>
<br>
steps:<br>
<br>
1)<br>
<br>
CREATE EXTENSION unaccent with SCHEMA public;<br>
<br>
response: OK.<br>
<br>
2) <br>
<br>
CREATE EXTENSION unaccent with SCHEMA public_test;<br>
<br>
response: SQL Error [42710]: ERROR: extension &quot;unaccent&quot; already =
exists<br>
<br>
I tryed:<br>
<br>
SET search_path =3D public_test;<br>
CREATE EXTENSION unaccent;<br>
<br>
=C2=A0and the response is: response: SQL Error [42710]: ERROR: extension<br=
>
&quot;unaccent&quot; already exists<br>
</blockquote><div><br></div><div><br></div><div>It doesn=E2=80=99t work and=
 isn=E2=80=99t documented as something that does work.=C2=A0 I really don=
=E2=80=99t see a need to say you cannot install the same extension multiple=
 times explicitly - the self-describing error seems sufficient.</div><div><=
br></div><div>David J.</div><div><br></div>

--000000000000aa09a205e0505e58--