[postgis-devel] [PostGIS] #320: Upgrade scripts PostGIS 1.4/1.5 need some work

[PostGIS]

#320: Upgrade scripts PostGIS 1.4/1.5 need some work
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 1.4.2
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 I think the 1.4 has same issues.  I think maybe we should move the DROP IF
 EXISTS functions out of COMMIT; block or handle the dependencies
 correctly.
  I had to do that to get the upgrade to work.   For example I get this
 when upgrading my PostGIS 1.5


 ERROR:  cannot drop function geom_accum(geometry[],geometry) because other
 objects depend on it
 DETAIL:  function geomunion_old(geometry) depends on function
 geom_accum(geometry[],geometry)
 HINT:  Use DROP ... CASCADE to drop the dependent objects too.

 ********** Error **********

 ERROR: cannot drop function geom_accum(geometry[],geometry) because other
 objects depend on it
 SQL state: 2BP01
 Detail: function geomunion_old(geometry) depends on function
 geom_accum(geometry[],geometry)
 Hint: Use DROP ... CASCADE to drop the dependent objects too.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/320>
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.