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 <l...@pcorp.us> 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 <kaido.vai...@gmail.com>
> *Sent:* Tuesday, December 24, 2024 5:51 AM
> *To:* Regina Obe <l...@pcorp.us>
> *Cc:* postgis-users@lists.osgeo.org
> *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 <l...@pcorp.us> 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 <kaido.vai...@gmail.com>
> *Sent:* Monday, December 23, 2024 6:15 AM
> *To:* postgis-users@lists.osgeo.org
> *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
>
>
