[postgis-users] shp2pgsl - couldn't parse objects in geometry

strk at refractions.net strk at refractions.net
Wed Sep 28 09:05:55 PDT 2005


Looks like you're trying to feed shp2pgsql output to an older
version of PostGIS. Please report output of

	SELECT postgis_full_version()

and

	shp2pgsql # with no args

--strk;

On Wed, Sep 28, 2005 at 12:07:14PM -0400, Stan Kim wrote:
> Hello,
> 
> I'm a new user and couldn't find answer to my question in archive...
> 
> I used shp2pgsql to create a .sql file.  When I attempted to load into 
> PostGIS, I got the message:
> 
> psql:cities.sql:4: ERROR:  couldnt parse objects in GEOMETRY
> 
> The offendng sql statement was:
> 
> INSERT INTO "cities" 
> ("city_name","gmi_admin","admin_name","fips_cntry","cntry_name","status","pop_rank","pop_class","port_id",the_geom) 
> VALUES ('Drammen','NOR-BSK','Buskerud','NO','Norway','Provincial 
> capital','6','50,000 to 
> 100,000','23780','01010000000000006066662440000000A099D94D40');
> 
> I am running with Windows installer inversion of PostgreSQL and the 
> PostGIS that came with it.
> 
> Thanks for any help.
> Stan
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list