Update topology 3.3.3 to 3.3.6 fails

kaido vaikla kaido.vaikla at gmail.com
Mon Dec 23 03:14:56 PST 2024


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20241223/e9d2dd1d/attachment.htm>


More information about the postgis-users mailing list