[postgis-devel] [PostGIS] #202: upgrade issues

[PostGIS]

#202: upgrade issues
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  postgis 1.4.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 I seem to have an issue after upgrade from 1.3.6 to 1.4.0 beta using the
 upgrade script.  I'm investigating to see if its something funky with my
 database.  Upgrade says it was okay, but:

 When I try to build a gist index on one of my tables, I get this error
 ERROR:  data type geometry has no default operator class for access method
 "gist"
 HINT:  You must specify an operator class for the index or define a
 default operator class for the data type.

 As expected -- if I try to upgrade a 1.3.6 that uses views with aggregates
 it fails.

 DETAIL:  view vwtest depends on function collect(geometry)
 HINT:  Use DROP ... CASCADE to drop the dependent objects too.

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

 ERROR: cannot drop function collect(geometry) because other objects depend
 on it
 SQL state: 2BP01
 Detail: view vwtest depends on function collect(geometry)
 Hint: Use DROP ... CASCADE to drop the dependent objects too.

 We should probably put a note somewhere in the upgrade instructions to
 have people drop such views and rebuild them after upgrade.  Minor I know
 and who knows maybe I'm the only one who does crazy things like this.

 The other issue -- If I try to upgrade 1.4.0SVN to 1.4 beta -- doesn't
 work -- again not a biggie since I presume no one will be doing this. Just
 thought I would mention it.  Gives:

 ERROR:  type "box3d_extent" already exists

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

 ERROR: type "box3d_extent" already exists
 SQL state: 42710

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/202>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS