[postgis-tickets] [PostGIS] #2673: Can't upgrade from postgis 2.0.4 to postgis 2.2.0

[PostGIS]

#2673: Can't upgrade from postgis 2.0.4 to postgis 2.2.0
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  robe         
     Type:  defect   |      Status:  new          
 Priority:  blocker  |   Milestone:  PostGIS 2.2.0
Component:  raster   |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by strk):

 I've tried to force calling postgis_extension_drop_if_exists for the
 function, and also added debugging prints in that function. Here's what i
 got:
 {{{
 pgt=# SELECT postgis_extension_drop_if_exists('postgis', 'DROP FUNCTION IF
 EXISTS _st_mapalgebra4unionfinal1(raster)'); DROP FUNCTION IF EXISTS
 _st_mapalgebra4unionfinal1(raster);
 NOTICE:  Got function _st_mapalgebra4unionfinal1(raster) is not a member
 of extension "postgis" (55000)
  postgis_extension_drop_if_exists
 ----------------------------------
  f
 (1 row)

 ERROR:  cannot drop function _st_mapalgebra4unionfinal1(raster) because
 other objects depend on it
 DETAIL:  extension postgis depends on function
 _st_mapalgebra4unionfinal1(raster)
 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
 }}}

 Pretty puzzling, isn't it ?
 According to ALTER EXTENSION DROP the function is not part of the
 extension, but according to DROP FUNCTION the postgis extension depends on
 it.

 I guess it's a dependency of some other object that ultimately is part of
 the extension ?
 An order-dependent issue ?

 Looking further...

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2673#comment:5>
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.