If I run SELECT postgis_extensions_upgrade(); should I change my code, or postgis will handle it for me ? I'm a dba not developer, hence I hesitate to change code.
________________________________ Gönderen: Regina Obe <l...@pcorp.us> adına postgis-users <postgis-users-boun...@lists.osgeo.org> Gönderildi: 17 Mart 2023 Cuma 11:29 Kime: 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org>; postgis-users-requ...@lists.osgeo.org <postgis-users-requ...@lists.osgeo.org> Konu: Re: [postgis-users] need help I would run SELECT postgis_extensions_upgrade(); SELECT postgis_extensions_upgrade(); That should do it. From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Bekir Niyaz Sent: Friday, March 17, 2023 3:11 AM To: postgis-users@lists.osgeo.org; postgis-users-requ...@lists.osgeo.org Subject: [postgis-users] need help Hello all, 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 deprecated func like 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()" 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 or just run "SELECT postgis_extensions_upgrade()" and find alternate function to deprecated ones? This is the prod server. best regards. thanks.
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users