On Tue, Apr 24, 2012 at 08:46:19AM -0400, Gold, Jack L (US SSA) wrote: > I recently dumped a database and attempted to rebuild postgis and my database > on an alternate server. I am receiving a message: > > ERROR: type "public.geometry" is only a shell > SQL state 42704 > > I'm pretty sure I put everything in correctly when rebuilding. Is anyone > aware of what this message is indicating? > > Running: postgreSQL 9.1, postGIS 2.0.1SVN, geos 3.3.2, gdal 1.9.0, proj 4.8.0
See the Hard Upgrade section in PostGIS manual: http://postgis.refractions.net/documentation/manual-svn/postgis_installation.html#hard_upgrade --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.0 ! | / 2.0 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users