[postgis-tickets] [PostGIS] #2279: Can't upgrade PostGIS from 2.0 (was: Can't upgrade PostGIS from 2.0 with extension)

[PostGIS]

#2279: Can't upgrade PostGIS from 2.0
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  robe         
     Type:  defect   |      Status:  new          
 Priority:  blocker  |   Milestone:  PostGIS 2.1.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 This is now SUPER SERIOUS.  To rule out extension as the culprit, I
 decided to install and upgrade the old-fashioned strk way.

 1) Create a new database and run the numerous scripts to install 2.0.3
 (both postgis.sql and rtpostgis.sql)
 2) then try to run our postgis_upgrade_20_21.sql

 and to my dismay -- I got the same error, was slightly more informative


 {{{

 ERROR:  cannot drop function
 geometry_gist_sel_2d(internal,oid,internal,integer) because other objects
 depend on it
 DETAIL:  operator &&(geometry,geometry) depends on function
 geometry_gist_sel_2d(internal,oid,internal,integer)
 operator class gist_geometry_ops_2d for access method gist depends on
 operator &&(geometry,geometry)
 HINT:  Use DROP ... CASCADE to drop the dependent objects too.

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

 ERROR: cannot drop function
 geometry_gist_sel_2d(internal,oid,internal,integer) because other objects
 depend on it
 SQL state: 2BP01
 Detail: operator &&(geometry,geometry) depends on function
 geometry_gist_sel_2d(internal,oid,internal,integer)
 operator class gist_geometry_ops_2d for access method gist depends on
 operator &&(geometry,geometry)
 Hint: Use DROP ... CASCADE to drop the dependent objects too.

 }}}

 HELP pramsey.

 Even worse my old db where I had replaced binaries had to swap back
 because it literally broke all my mapping apps since && is so critical.

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