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?
