Does:
SELECT postgis_full_version();
Work, I’m wondering if maybe you have missed some other updates. This could be a bug.
From: postgis-users [mailto:[email protected]] On Behalf Of Bekir Niyaz
Sent: Friday, March 17, 2023 5:08 AM
To: 'PostGIS Users Discussion' <[email protected]>; [email protected]
Subject: [postgis-users] Ynt: need help
I ran SELECT postgis_extensions_upgrade();
now Im gettin too many, can you help
ERROR,42883,"function st_force_2d(geometry) does not exist"
Gönderen: Regina Obe <[email protected]> adına postgis-users <[email protected]>
Gönderildi: 17 Mart 2023 Cuma 11:29
Kime: 'PostGIS Users Discussion' <[email protected]>; [email protected] <[email protected]>
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:[email protected]] On Behalf Of Bekir Niyaz
Sent: Friday, March 17, 2023 3:11 AM
To: [email protected]; [email protected]
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 [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
