[postgis-users] Ynt: need help

[Regina Obe]

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:postgis-users-bounces at lists.osgeo.org] On Behalf
Of Bekir Niyaz
Sent: Friday, March 17, 2023 5:08 AM
To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>;
postgis-users-request at lists.osgeo.org
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 <lr at pcorp.us <mailto:lr at pcorp.us> > adına postgis-users
<postgis-users-bounces at lists.osgeo.org
<mailto:postgis-users-bounces at lists.osgeo.org> >
Gönderildi: 17 Mart 2023 Cuma 11:29
Kime: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org
<mailto:postgis-users at lists.osgeo.org> >;
postgis-users-request at lists.osgeo.org
<mailto:postgis-users-request at lists.osgeo.org>
<postgis-users-request at lists.osgeo.org
<mailto:postgis-users-request at 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-bounces at lists.osgeo.org] On Behalf
Of Bekir Niyaz
Sent: Friday, March 17, 2023 3:11 AM
To: postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> ;
postgis-users-request at lists.osgeo.org
<mailto:postgis-users-request at 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20230317/ba8d2d40/attachment.htm>