<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><div dir="auto">I did workaround, create function named st_force_2d(geom) than calling st_force2d(geom) it worked, and  the former problems dissappeared when upgrade extension.<div dir="auto">Anyway so far everything works well</div><div dir="auto">thank for reply.</div><div dir="auto"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">17 Mar 2023 18:52 tarihinde Regina Obe <lr@pcorp.us> yazdı:<br type="attribution"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d">Does:</span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d"> </span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d">SELECT postgis_full_version();</span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d"> </span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d">Work, I’m wondering if maybe you have missed some other updates.  This could be a bug.</span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d"> </span></p><div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4pt"><div><div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0in 0in 0in"><p><b><span style="font-size:11pt;font-family:'calibri' , sans-serif">From:</span></b><span style="font-size:11pt;font-family:'calibri' , sans-serif"> postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Bekir Niyaz<br><b>Sent:</b> Friday, March 17, 2023 5:08 AM<br><b>To:</b> 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org>; postgis-users-request@lists.osgeo.org<br><b>Subject:</b> [postgis-users] Ynt: need help</span></p></div></div><p> </p><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black">I ran </span><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d;background:white">SELECT postgis_extensions_upgrade();</span><span style="font-family:'calibri' , sans-serif;color:black"></span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black">now Im gettin too many, can you help</span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black">ERROR,42883,"function st_force_2d(geometry) does not exist"</span></p></div><div><p><span style="font-family:'calibri' , sans-serif;color:black"> </span></p></div><div align="center" style="text-align:center"><hr size="2" width="98%" align="center"></div><div><p><b><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:black">Gönderen:</span></b><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:black"> Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> adına postgis-users <<a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>><br><b>Gönderildi:</b> 17 Mart 2023 Cuma 11:29<br><b>Kime:</b> 'PostGIS Users Discussion' <<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>>; <a href="mailto:postgis-users-request@lists.osgeo.org">postgis-users-request@lists.osgeo.org</a> <<a href="mailto:postgis-users-request@lists.osgeo.org">postgis-users-request@lists.osgeo.org</a>><br><b>Konu:</b> Re: [postgis-users] need help</span> </p><div><p> </p></div></div><div><div><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d">I would run</span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d"> </span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d">SELECT postgis_extensions_upgrade();</span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d">SELECT postgis_extensions_upgrade();</span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d"> </span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d">That should do it. </span></p><p><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:#1f497d"> </span></p><div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4pt"><div><div style="border:none;border-top:solid #e1e1e1 1pt;padding:3pt 0in 0in 0in"><p><b><span style="font-size:11pt;font-family:'calibri' , sans-serif">From:</span></b><span style="font-size:11pt;font-family:'calibri' , sans-serif"> postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Bekir Niyaz<br><b>Sent:</b> Friday, March 17, 2023 3:11 AM<br><b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>; <a href="mailto:postgis-users-request@lists.osgeo.org">postgis-users-request@lists.osgeo.org</a><br><b>Subject:</b> [postgis-users] need help</span></p></div></div><p> </p><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black">Hello all,</span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black">I move db servers to newer servers but I misinstalled the new version of postgis, former posgis version was 3.0.0 but in new servers I realize I installed 3.3.2, therefore I get some errors <span style="background:white"> deprecated func</span> like  </span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black">ERROR,0A000,"A stored procedure tried to use deprecated C function 'pgis_geometry_union_finalfn'","Library function 'pgis_geometry_union_finalfn' was deprecated in PostGIS 3.3.2","Consider running: SELECT postgis_extensions_upgrade()"</span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black"> </span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black">Now what do you recommend me to do, should I remove postgis33_12-3.3.2-1.rhel8.x86_64 package and install postgis30_12.x86_64</span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black">or just run "<span style="background:white">SELECT postgis_extensions_upgrade()" and find alternate function to deprecated ones?</span></span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black">This is the prod server.</span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black"> </span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black;background:white">best regards.</span></p></div><div><p style="background:white"><span style="font-family:'calibri' , sans-serif;color:black;background:white">thanks.</span></p></div></div></div></div></div></div></div></blockquote></div><br></div>