RE: Update topology 3.3.3 to 3.3.6 fails

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 <[email protected]> 
Sent: Monday, December 23, 2024 6:15 AM
To: [email protected]
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