Thanks Sandro. That was exactly it and gives me more insight to what I'm doing.
--Jack -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Sandro Santilli Sent: Tuesday, April 24, 2012 8:51 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] type "public.geometry" is only a shell 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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users