How to debug extension update

From: kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: How to debug extension update
Date: 2025-01-06 16:49:16
Message-ID: CA+427g80oqbNoq4JJYH0Y6rX=p32_ZhRzaEeECQV9TAN_UqjRw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-01-06 17:13:35 Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster
Previous Message kasem adel 2025-01-05 17:57:47 Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster