[postgis-devel] [PostGIS] #198: shp2pgsql gives bad output on bad input
PostGIS
trac at osgeo.org
Mon Jun 15 10:27:25 PDT 2009
#198: shp2pgsql gives bad output on bad input
---------------------+------------------------------------------------------
Reporter: pramsey | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: postgis 1.4.0
Component: postgis | Version: trunk
Keywords: |
---------------------+------------------------------------------------------
Using the building_oops data from #167, you get I get the following
output:
{{{
Heron-2:buildings_oops pramsey$ shp2pgsql buildings_oops.shp b
Shapefile type: PolygonZ
Postgis type: MULTIPOLYGON[4]
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "b" (gid serial PRIMARY KEY,
"layer" varchar(254),
"elevation" numeric,
"shape_leng" numeric,
"shape_area" numeric);
SELECT AddGeometryColumn('','b','the_geom','-1','MULTIPOLYGON',4);
ERROR: geometry requires more points
INSERT INTO "b" ("layer","elevation","shape_leng","shape_area",the_geom)
VALUES
('S-BUILDING','1384.22300000','0.00000000000','0.00000000000',Heron-2:buildings_oops
pramsey$
}}}
Again, I re-iterate, that we should not be doing validity checking in the
loader.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/198>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS
More information about the postgis-devel
mailing list