I vaguely recall running into this issue when doing CREATE EXTENSION
postgis_topology; But haven’t seen the issue in recent versions of postgis
(e.g. 3.4 and above) and can’t remember how I worked around it.
Is your search_path set just for your user setting or for the database?
Have you tried resetting the search path.
Something like:
set search_path=postgis, topology;
alter extension postgis_topology update to "3.3.6";
Are you able to use a newer PostGIS say 3.3.7 (3.3.8 came out yesterday so
might not be available yet in most distros),
From: kaido vaikla <kaido.vai...@gmail.com>
Sent: Monday, December 23, 2024 6:15 AM
To: postgis-users@lists.osgeo.org
Subject: Update topology 3.3.3 to 3.3.6 fails
Hi,
Need some help.
teglms=# \dx post*
List of installed extensions
Name | Version | Schema | Description
------------------+---------+----------+------------------------------------------------------------
postgis | 3.3.6 | postgis | PostGIS geometry and geography spatial
types and functions
postgis_raster | 3.3.6 | postgis | PostGIS raster types and functions
postgis_topology | 3.3.3 | topology | PostGIS topology spatial types and
functions
(3 rows)
teglms=# alter extension postgis_topology update to "3.3.6";
ERROR: type "geometry" does not exist
teglms=# \dT+ geometry
List of data types
Schema | Name | Internal name | Size | Elements | Owner | Access
privileges | Description
---------+----------+---------------+------+----------+------------+-------------------+--------------------------------------------------------------------------------------
postgis | geometry | geometry | var | | eglmsadmin |
| postgis type: The type representing spatial features with planar
coordinate systems.
(1 row)
teglms=# select user;
user
------------
eglmsadmin
(1 row)
teglms=# show search_path ;
search_path
-------------------
postgis, topology
(1 row)
Why update can't find a type geometry?
br
Kaido
