[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:               
----------------------+-----------------------------------------------------
Comment (by robe):

 Paul,

 Sorry about that.  I'm retracing my steps by reloading my database from
 1.3.6 backup.

 1) This is a database that has gone thru many upgrades (form 1.1) -- so
 loading it from a PostgreSQL 8.2 (1.3.6) to PostgreSQL 8.4 RC1

 2) Then upgrading that using the postgis_upgrade.sql (first error I got
 was about my view vwtest -- so dropped that and reran script).  Script
 said it was fine.

 3) Did select postgis_full_version() -- stated I was running
 "POSTGIS="1.4.0b1" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August
 2008" USE_STATS" (looks good)

 3) Ran some queries -- super slow and Hmm I noticed non of my tables got
 the gist index (but forgot to check if they had them before the upgrade so
 this might be a restore issue or my 1.3.6 install on PostgreSQL 8.3).

 4) Proceeded to build index on table -- bam
 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.

 (Looked at my Operator Classes section and gist for geometry is missing).

 I suspect this may be a false alarm that maybe there is something wrong
 with my 1.3.6 install on PostgreSQL 8.4

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