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

Gold, Jack L (US SSA) jack.gold at baesystems.com
Tue Apr 24 06:26:53 PDT 2012

Thanks Sandro. That was exactly it and gives me more insight to what I'm doing.


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at 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:


  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com

postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list