1) requires = 'postgis'
$ cat postgis_topology.control
# postgis topology extension
comment = 'PostGIS topology spatial types and functions'
default_version = '3.3.6'
relocatable = false
schema = topology
requires = postgis
So i changed it
requires = postgis -> requires = 'postgis'
but no help.
2) about missing access privileges
I checked different databases with
\dT+ *.*
data types "Access privileges" is everywhere empty.
As my subject is, is it there a way somehow debug "alter extension update" statement to figure out what is going on behind this?
br
Kaido
On Mon, 6 Jan 2025 at 22:05, Zaid Shabbir <zaidshabbir@xxxxxxxxx> wrote:
Hello,I am also getting the same error without the upgrade scenario.postgres=# CREATE EXTENSION postgis SCHEMA postgis;
CREATE EXTENSION
postgres=# CREATE EXTENSION postgis_topology SCHEMA topology;
ERROR: type "geometry" does not exist
postgres=# show search_path ;
search_path
---------------------------
postgis, topology, public
(1 row)
postgres=# CREATE EXTENSION postgis_topology;
ERROR: type "geometry" does not exist
postgres=# SELECT current_schema();
current_schema
----------------
postgis
(1 row)
Regards,ZaidOn Tue, Jan 7, 2025 at 12:58 AM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:kaido vaikla <kaido.vaikla@xxxxxxxxx> writes:
> Why update can't find an extension, while i can describe it and search_path
> seems to be correct?
Extension scripts are not run with the session's prevailing
search_path, but with a search path built from the extension's
dependencies. In this case, schema postgis would be included
in that path only if extension postgis_topology specifies
requires = 'postgis'
in its postgis_topology.control file. It kinda sounds like that
might be missing? If it's present, then Ron's thought about
missing access privileges for the postgis schema might be the
answer.
regards, tom lane
