[postgis-users] Error while importing data

[Aditya]

On Sat, Jun 04, 2005 at 01:21:01AM +0200, strk at refractions.net wrote:
> It sounds as you upgraded postgis in a wrong manner,
> can you show the output of SELECT postgis_full_version() ?

Hm, that's odd, I didn't upgrade postgis, I did a fresh install...but in any
case:

grot=> SELECT postgis_full_version();
                   postgis_full_version
----------------------------------------------------------
 POSTGIS="1.0.1" USE_STATS DBPROC="0.3.0" RELPROC="0.3.0"
(1 row)

grot=> select version();
                                              version
----------------------------------------------------------------------------------------------------
 PostgreSQL 8.0.3 on sparc64-unknown-freebsd6.0, compiled by GCC gcc (GCC)
3.4.2 [FreeBSD] 20040728
(1 row)

Thanks,
Adi

> On Thu, Jun 02, 2005 at 09:03:20PM +0000, Aditya wrote:
> > I'm getting an error similar to what was described in this thread from March
> > 2005. I searched for 
> > 
> >  postgis "ERROR:  Invalid type in wbk"
> > 
> > and found this thread, but with a fix that seems not to apply to the
> > shapefiles I'm trying to import. I would appreciate it greatly if someone else
> > could try and reproduce this error (and thereby implicate the shapefile :-)
> > 
> > The shapefile was produced from:
> > 
> >   http://www.esri.com/data/download/basemap/index.html
> > 
> > and trying to import it using shp2pgsql on fresh installs of:
> > 
> >   postgis 1.0.1
> >   postgresql 8.0.3
> > 
> > shapefile and resulting .sql file appended. The transcript of my sessions are
> > below.
> > 
> > Thanks,
> > Adi
> > 
> > some[ttyp0]:aditya/usr/local/src/gis/sa> /usr/local/pgsql/bin/shp2pgsql -d -D
> > Country\ Boundaries\ 2.shp geoserver.country > country.sql
> > Shapefile type: Polygon
> > Postgis type: MULTIPOLYGON[2]
> > some[ttyp0]:aditya/usr/local/src/gis/sa> psql -d grot -U geoserver -f country.sql 
> > psql:country.sql:1: ERROR:  column not found in geometry_columns
> > table
> > CONTEXT:  SQL statement "SELECT  DropGeometryColumn('', $1 , $2 , $3 )"
> > PL/pgSQL function "dropgeometrycolumn" line 4 at select into variables
> > psql:country.sql:2: ERROR:  table "country" does not exist
> > BEGIN
> > psql:country.sql:4: NOTICE:  CREATE TABLE will create implicit sequence
> > "country_gid_seq" for serial column "country.gid"
> > psql:country.sql:4: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit
> > index "country_pkey" for table "country"
> > CREATE TABLE
> >                                   addgeometrycolumn
> > --------------------------------------------------------------------------------------
> >  geoserver.country.the_geom SRID:-1 TYPE:MULTIPOLYGON DIMS:2
> >  geometry_column fixed:0
> > (1 row)
> > 
> > psql:country.sql:6: ERROR:  Invalid type in wbk
> > CONTEXT:  COPY country, line 1, column the_geom:
> > "00000000060000000100000000030000000100000070404E25B23571D1D4404259FF2E48E8A84050296B3354C122404259FF..."
> > ROLLBACK