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?
Type geometry is owned by eglmsadmin, but there do not appear to be any Access privileges granted. Thus, maybe whatever user you connected as doesn't have privs to access it?
