[postgis-users] PostGIS 1.5 -> 2.4 compatibility

Regina Obe lr at pcorp.us
Tue Aug 18 13:14:28 PDT 2020

You can use the legacy.sql script which should be packaged with most distributions in the contrib folder – I think we still package it.

Though fewer and fewer people use it so let us know if you run into issues with it or you can’t find it in your distribution.


Now as to






We have never had such types – we did and still have geometrytype(geometry)


So your above might come from some other package you had  like possibly ArcSDE.


From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Darafei "Kom?pa" Praliaskouski
Sent: Tuesday, August 18, 2020 3:31 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] PostGIS 1.5 -> 2.4 compatibility




Please note 2.4 is not the latest version, 3.0 is.


You're expected to add ST_ prefix to all the functions to find their modern name. ST_SRID, ST_GeometryType in your example.



On Tue, Aug 18, 2020 at 10:26 PM S Bob <sbob at quadratum-braccas.com <mailto:sbob at quadratum-braccas.com> > wrote:


We are upgrading from postgis 1.5 -> 2.4

Is there a compat module that will provide for the missing functionality 
listed below:

srid(geometry) is missing

geometrytype(shapepoint) is missing

geometrytype(shapepointplanar) is missing

Or is there an alternate for these functions in 2.4?


postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 



Darafei Praliaskouski

Support me: http://patreon.com/komzpa

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200818/02388d51/attachment.html>

More information about the postgis-users mailing list