MIME-Version: 1.0
In-Reply-To: <CABYQJUR6xH1ERcV_7hrc13v+pVfjuURqx2hmqhp+No9ScWTOrw@mail.gmail.com>
References: <CABYQJUR6xH1ERcV_7hrc13v+pVfjuURqx2hmqhp+No9ScWTOrw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 26 Mar 2026 14:07:39 -0700
Message-ID: <CAKFQuwZ7HDGErCWGnmb_NZHOBoL4GU4xkNeA-rswjtb8uiEXfA@mail.gmail.com>
Subject: Re: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
To: =?UTF-8?Q?S=C3=A9rgio_Duarte?= <duartes@gmail.com>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000592d66064df3c602"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZ7HDGErCWGnmb_NZHOBoL4GU4xkNeA-rswjtb8uiEXfA%40mail.gmail.com>
Precedence: bulk

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

On Thursday, March 26, 2026, S=C3=A9rgio Duarte <duartes@gmail.com> wrote:

> version
> PostgreSQL 16.11 (Debian 16.11-1.pgdg12+1) on x86_64-pc-linux-gnu,
> compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
>
> create extension if not exists postgis with schema sigop;
>
> Query execution failed
>
> Reason:
> SQL Error [42501]: ERROR: permission denied to create
> "pg_catalog.geometry_dump"
>   Detail: System catalog modifications are currently disallowed.
>

This seems more likely to be user-error than a bug.  At minimum you will
need to specify the version of PostGIS you are installing in addition to
the platform and server into which it is being installed.  I=E2=80=99m also=
 pretty
sure you don=E2=80=99t get to specify =E2=80=9Cwith schema=E2=80=9D.  You p=
robably need to re-read
the instructions for how to install PostGIS and follow them exactly.  That
will likely result in an error-free installation.  If not, you probably
should report any issues to them.  If they have an issue with the core
server they can then report it here.

David J.

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

On Thursday, March 26, 2026, S=C3=A9rgio Duarte &lt;<a href=3D"mailto:duart=
es@gmail.com">duartes@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmai=
l_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left=
:1ex"><div dir=3D"ltr"><div>version<br>PostgreSQL 16.11 (Debian 16.11-1.pgd=
g12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 1=
2.2.0, 64-bit</div><div><span style=3D"background-color:rgb(247,247,247);pa=
dding:0px 0px 0px 2px"><span style=3D"color:rgb(0,0,0);font-family:monospac=
e;font-size:10pt;white-space:pre-wrap"><span style=3D"color:rgb(128,0,0);fo=
nt-weight:bold"><br></span></span></span></div><div><span style=3D"backgrou=
nd-color:rgb(247,247,247);padding:0px 0px 0px 2px"><span style=3D"color:rgb=
(0,0,0);font-family:monospace;font-size:10pt;white-space:pre-wrap"><span st=
yle=3D"color:rgb(128,0,0);font-weight:bold">create</span><span> </span><spa=
n style=3D"color:rgb(128,0,0);font-weight:bold">extension</span><span> </sp=
an><span style=3D"color:rgb(128,0,0);font-weight:bold">if</span><span> </sp=
an><span style=3D"color:rgb(128,0,0);font-weight:bold">not</span><span> </s=
pan><span style=3D"color:rgb(128,0,0);font-weight:bold">exists</span><span>=
 </span><span>postgis</span><span> </span><span style=3D"color:rgb(128,0,0)=
;font-weight:bold">with</span><span> </span><span style=3D"color:rgb(128,0,=
0);font-weight:bold">schema</span><span> </span><span>sigop</span><span sty=
le=3D"color:rgb(255,0,0)">;</span></span></span></div><div><br></div><div>Q=
uery execution failed</div><br>Reason:<br>SQL Error [42501]: ERROR: permiss=
ion denied to create &quot;pg_catalog.geometry_dump&quot;<br>=C2=A0 Detail:=
 System catalog modifications are currently disallowed.</div></blockquote><=
div><br></div><div>This seems more likely to be user-error than a bug.=C2=
=A0 At minimum you will need to specify the version of PostGIS you are inst=
alling in addition to the platform and server into which it is being instal=
led.=C2=A0 I=E2=80=99m also pretty sure you don=E2=80=99t get to specify =
=E2=80=9Cwith schema=E2=80=9D.=C2=A0 You probably need to re-read the instr=
uctions for how to install PostGIS and follow them exactly.=C2=A0 That will=
 likely result in an error-free installation.=C2=A0 If not, you probably sh=
ould report any issues to them.=C2=A0 If they have an issue with the core s=
erver they can then report it here.<br></div><div><br></div><div>David J.</=
div><div><br></div>

--000000000000592d66064df3c602--