Hi,
Updating extension fails:
ERROR: type does not exist
but i can describe it, ie search_path is correct.
pg version 15.10.
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 an extension, while i can describe it and search_path seems to be correct?
br
Kaido
