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

[R. Paul Warriner]

Thank you kindly, strk
Early morning eye strain, now back to the 70" lake effect, with 60 F and 45
mph gusts coming. :)

For the thread notes:
I wasn't able to locate the source to make core sync completely, but once I
had the following, everything went fine:
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.3 r11132" need upgrade) TOPOLOGY
(topology procs from "2.0.3 r11132" need upgrade) RASTER
(raster procs from "2.0.3 r11132" need upgrade)

Paul

-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Sandro Santilli
Sent: Monday, November 24, 2014 4:26 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] st_intersection function does not exist after
upgrade

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
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users