[postgis-users] type "public.geometry" is only a shell

[Sandro Santilli]

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------'