[postgis-users] st_intersection function does not exist after upgrade

Sandro Santilli strk at keybit.net
Mon Nov 24 01:26:21 PST 2014


On Sun, Nov 23, 2014 at 12:10:57PM -0500, R. Paul Warriner wrote:

> From (which started as a 1.5, and had manual raster configurations at 2.0) -
> 
> "POSTGIS="2.0.3 r11128" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March
> 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8"
> LIBJSON="UNKNOWN" (core procs from "2.0.0 r9605" need upgrade) TOPOLOGY
> (topology procs from "2.0.0 r9605" need upgrade) RA (...)"
> 
>  
> To-
> 
> "POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3924" PROJ="Rel. 4.8.0, 6
> March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8"
> LIBJSON="UNKNOWN" TOPOLOGY RASTER"
> 
>  
> 
> ERROR:  function st_intersection(raster, raster, regprocedure) does not
> exist

...

First thing to note is that your 2.0.3 install is not correct
(core procs are from 2.0.0). You should probably fix that first.
Running the postgis_upgrade.sql from 2.0.3 should get you there.
Best if you also run the topology_upgrade.sql from the same version.

Then, try upgrading to 2.1.4.
If the problem persist, try stepping by 2.0.6 first (latest stable
in the 2.0 branch) and then against to 2.1.4.
If the problem persists, file a ticket.

Thank you.

--strk;

 ()  ASCII ribbon campaign  --  Keep it simple !
 /\  http://strk.keybit.net/rants/ascii_mails.txt  


More information about the postgis-users mailing list