Request a Demo
Home   >   mailing lists

POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump" - Mailing list pgsql-bugs

From Sérgio Duarte
Subject POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
Date
Msg-id CABYQJUR6xH1ERcV_7hrc13v+pVfjuURqx2hmqhp+No9ScWTOrw@mail.gmail.com
Whole thread
Responses Re: POSTGIS | SQL Error [42501]: ERROR: permission denied to create "pg_catalog.geometry_dump"
List pgsql-bugs
Tree view
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.

pgsql-bugs by date:

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