public inbox for [email protected]
help / color / mirror / Atom feedFrom: kaido vaikla <[email protected]>
To: pgsql-admin <[email protected]>
Subject: How to debug extension update
Date: Mon, 6 Jan 2025 18:49:16 +0200
Message-ID: <CA+427g80oqbNoq4JJYH0Y6rX=p32_ZhRzaEeECQV9TAN_UqjRw@mail.gmail.com> (raw)
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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: How to debug extension update
In-Reply-To: <CA+427g80oqbNoq4JJYH0Y6rX=p32_ZhRzaEeECQV9TAN_UqjRw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox