RE: Update topology 3.3.3 to 3.3.6 fails

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] <mailto:[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] <mailto:[email protected]> > 
Sent: Monday, December 23, 2024 6:15 AM
To: [email protected] <mailto:[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