Changes between Initial Version and Version 6 of Ticket #202


Ignore:
Timestamp:
Jun 18, 2009, 8:33:28 AM (15 years ago)
Author:
pramsey
Comment:

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.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #202 – Description

    initial v6  
    1 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:
    2 
    3 When I try to build a gist index on one of my tables, I get this error
    4 ERROR:  data type geometry has no default operator class for access method "gist"
    5 HINT:  You must specify an operator class for the index or define a default operator class for the data type.
    6 
    7 As expected -- if I try to upgrade a 1.3.6 that uses views with aggregates it fails.
    8 
    9 DETAIL:  view vwtest depends on function collect(geometry)
    10 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
    11 
    12 ********** Error **********
    13 
    14 ERROR: cannot drop function collect(geometry) because other objects depend on it
    15 SQL state: 2BP01
    16 Detail: view vwtest depends on function collect(geometry)
    17 Hint: Use DROP ... CASCADE to drop the dependent objects too.
    18 
    19 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.
    20 
    21 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:
     1 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:
    222
    233ERROR:  type "box3d_extent" already exists