POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"

From: Sérgio Duarte <duartes(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
Date: 2026-03-26 20:38:52
Message-ID: CABYQJUR6xH1ERcV_7hrc13v+pVfjuURqx2hmqhp+No9ScWTOrw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2026-03-26 21:07:39 Re: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
Previous Message Andrei Lepikhov 2026-03-26 19:59:13 Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables