[postgis-tickets] [PostGIS] #3028: create extension postgis from unpackaged - ERROR: function st_intersection(raster, integer, geometry) does not exist

[PostGIS]

#3028: create extension postgis from unpackaged - ERROR:  function
st_intersection(raster, integer, geometry) does not exist
--------------------+-------------------------------------------------------
 Reporter:  strk    |       Owner:  robe         
     Type:  defect  |      Status:  new          
 Priority:  medium  |   Milestone:  PostGIS 2.2.0
Component:  raster  |     Version:  trunk        
 Keywords:          |  
--------------------+-------------------------------------------------------

Comment(by strk):

 But indeed I don't have it:

 {{{
 strk=# alter FUNCTION st_intersection (rast raster, band integer, geomin
 geometry) security invoker;
 ERROR:  function st_intersection(raster, integer, geometry) does not exist
 }}}

 Nor rtpostgis_upgrade.sql installs it for me, which is weird because I do
 see the line adding it.


 FOUND: the rtpostgis_upgrade.sql first drops it (as it changed signature
 or something) then creates it and finally drops it again as "obsoleted"
 (which evidently isn't).

 It's dropped with lots of other functions on line 8698 of
 rtpostgis_upgrade.sql for me as the final step. Initially dropped on line
 532 and recreated on line 6417

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3028#comment:4>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.