[postgis-devel] [PostGIS] #1849: Error during DB migrate from Postgis 1.4 to 2.0

[PostGIS]

#1849: Error during DB migrate from Postgis 1.4 to 2.0
---------------------+------------------------------------------------------
 Reporter:  davidMF  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.1
Component:  postgis  |     Version:  2.0.x        
 Keywords:  Upgrade  |  
---------------------+------------------------------------------------------
 Hello.
 After my post on postgis-users-bounces at postgis.refractions.net, Regina
 advices me to post a ticket here.

 My problem is that I'm trying to import data from PostGIS 1.4 (Postgres
 8.3) to PostGIS 2.0 (Postgres 9.1).

 I'd installed PostGIS with extension and created database with it.
 As I have a very old version of database, I ran legacy.sql
 During Hard Upgrade from dump (created with -Fc option), I got only one
 error during create table statement because it uses
 box3d_extent.

 ERROR: type < box3d_extent > does not exists

 I think it's an old type of data ? How to resolve it ?
 Is it a miss in legacy.sql ?

 Thanks for all.
 David.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1849>
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.