[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        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Old description:

> 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

New description:

 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

Comment (by pramsey):

 Trying to replicate your situation (table with existing index, do upgrade)
 I'm not seeing the same effect, so I'm going to alter the description of
 this issue to exclude everything except the final case, which is the
 (upcoming) issue of 1.4.X upgrades, which won't work because the script is
 hard-coded to expect a 1.3->1.4 upgrade.

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