Re: Update topology 3.3.3 to 3.3.6 fails

This is one session "flow" output.
Starting with
teglms=# \dx post*

and ending

teglms=# show search_path ;
    search_path
-------------------
 postgis, topology
(1 row)

Some other suggestions
br
Kaido

On Tue, 24 Dec 2024 at 16:54, Regina Obe <[email protected]> wrote:

> Yah that part I read.  I was just thinking that maybe during the ALTER
> EXTENSION process it ignores whatever search_path the user has, but might
> not ignore the session search_path.
>
> If you do show search_path, it’s what the search_path is for YOU, but not
> necessarily what will be in effect when ALTER EXTENSION runs.
>
>
>
> So that is why I was asking you to reset it for the session.
>
>
>
> That said I forget if the search_path is also reset during ALTER EXTENSION
> so that may not work anyway.
>
>
>
>
>
> *From:* kaido vaikla <[email protected]>
> *Sent:* Tuesday, December 24, 2024 5:51 AM
> *To:* Regina Obe <[email protected]>
> *Cc:* [email protected]
> *Subject:* Re: Update topology 3.3.3 to 3.3.6 fails
>
>
>
> Regina,
> in my first post you see:
>
> teglms=# show search_path ;
>     search_path
> -------------------
>  postgis, topology
> (1 row)
>
>
> br
> Kaido
>
>
>
> On Tue, 24 Dec 2024 at 03:06, Regina Obe <[email protected]> wrote:
>
> I vaguely recall running into this issue when doing CREATE EXTENSION
> postgis_topology;  But haven’t seen the issue in recent versions of postgis
> (e.g. 3.4 and above) and can’t remember how I worked around it.
>
>
>
>
>
> Is your search_path set just for your user setting or for the database?
>
>
>
> Have you tried resetting the search path.
>
>
>
> Something like:
>
>
>
> set search_path=postgis, topology;
>
>
>
> alter extension postgis_topology update to "3.3.6";
>
>
>
>
>
> Are you able to use a newer PostGIS say 3.3.7 (3.3.8 came out yesterday so
> might not be available yet in most distros),
>
>
>
>
>
> *From:* kaido vaikla <[email protected]>
> *Sent:* Monday, December 23, 2024 6:15 AM
> *To:* [email protected]
> *Subject:* Update topology 3.3.3 to 3.3.6 fails
>
>
>
> Hi,
> Need some help.
>
> 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 a type geometry?
>
> br
> Kaido
>
>