Re: How to debug extension update

On Mon, Jan 6, 2025 at 11:49 AM kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com> wrote:

> 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?
>
>
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?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!