<div dir="ltr"><div class="gmail_default" style="font-family:monospace,monospace">Regina,<br>in my first post you see:<br><br>teglms=# show search_path ;<br>    search_path<br>-------------------<br> postgis, topology<br>(1 row)<br><br><br>br<br>Kaido</div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Tue, 24 Dec 2024 at 03:06, Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-4669799591361330621"><div lang="EN-US" style="overflow-wrap: break-word;"><div class="m_-4669799591361330621WordSection1"><p class="MsoNormal"><span style="font-size:11pt">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.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt">Is your search_path set just for your user setting or for the database?<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt">Have you tried resetting the search path.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt">Something like:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt">set search_path=postgis, topology;<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-family:"Courier New"">alter extension postgis_topology update to "3.3.6";<u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:"Courier New""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-family:"Courier New""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-family:"Courier New"">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), <u></u><u></u></span></p><p class="MsoNormal"><span style="font-family:"Courier New""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p><div style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt"><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in"><p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:Calibri,sans-serif"> kaido vaikla <<a href="mailto:kaido.vaikla@gmail.com" target="_blank">kaido.vaikla@gmail.com</a>> <br><b>Sent:</b> Monday, December 23, 2024 6:15 AM<br><b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> Update topology 3.3.3 to 3.3.6 fails<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal" style="margin-bottom:12pt"><span style="font-family:"Courier New"">Hi, <br>Need some help.<br><br>teglms=# \dx post*<br>                                    List of installed extensions<br>       Name       | Version |  Schema  |                        Description<br>------------------+---------+----------+------------------------------------------------------------<br> postgis          | 3.3.6   | postgis  | PostGIS geometry and geography spatial types and functions<br> postgis_raster   | 3.3.6   | postgis  | PostGIS raster types and functions<br> postgis_topology | 3.3.3   | topology | PostGIS topology spatial types and functions<br>(3 rows)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-family:"Courier New"">teglms=# alter extension postgis_topology update to  "3.3.6";<br>ERROR:  type "geometry" does not exist<br>teglms=# \dT+ geometry<br>                                                                              List of data types<br> Schema  |   Name   | Internal name | Size | Elements |   Owner    | Access privileges |                                     Description<br>---------+----------+---------------+------+----------+------------+-------------------+--------------------------------------------------------------------------------------<br> postgis | geometry | geometry      | var  |          | eglmsadmin |                   | postgis type: The type representing spatial features with planar coordinate systems.<br>(1 row)<br><br>teglms=# select user;<br>    user<br>------------<br> eglmsadmin<br>(1 row)<u></u><u></u></span></p></div><div><p class="MsoNormal"><span style="font-family:"Courier New""><u></u> <u></u></span></p></div><div><p class="MsoNormal"><span style="font-family:"Courier New"">teglms=# show search_path ;<br>    search_path<br>-------------------<br> postgis, topology<br>(1 row)<br><br>Why update can't find a type geometry?<br><br>br<br>Kaido<u></u><u></u></span></p></div></div></div></div></div></div></blockquote></div>