| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Sérgio Duarte <duartes(at)gmail(dot)com> |
| Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump" |
| Date: | 2026-03-26 21:07:39 |
| Message-ID: | CAKFQuwZ7HDGErCWGnmb_NZHOBoL4GU4xkNeA-rswjtb8uiEXfA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thursday, March 26, 2026, Sérgio Duarte <duartes(at)gmail(dot)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’m also pretty
sure you don’t get to specify “with schema”. You probably 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2026-03-26 23:44:40 | Re: Segmentation fault in PostgreSQL 17.7 during REINDEX TABLE CONCURRENTLY |
| Previous Message | Sérgio Duarte | 2026-03-26 20:38:52 | POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump" |