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

[Sandro Santilli]

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