[postgis-tickets] [PostGIS] #3662: shp2pgsql does not work in debug mode

[PostGIS]

#3662: shp2pgsql does not work in debug mode
---------------------+---------------------------
 Reporter:  komzpa   |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.3.1
Component:  postgis  |    Version:  2.3.x
 Keywords:           |
---------------------+---------------------------
 {{{
 shp2pgsql -s 3857 -d -D -g geom -I data/osm/water_polygons.shp
 water_polygons | psql -X

 Shapefile type: Polygon
 Postgis type: MULTIPOLYGON[2]
 SET
 SET
 ERROR:  column not found in geometry_columns table
 CONTEXT:  PL/pgSQL function dropgeometrycolumn(character varying,character
 varying,character varying,character varying) line 34 at RAISE
 SQL statement "SELECT DropGeometryColumn('',$1,$2,$3)"
 PL/pgSQL function dropgeometrycolumn(character varying,character
 varying,character varying) line 5 at SQL statement
 NOTICE:  table "water_polygons" does not exist, skipping
 DROP TABLE
 BEGIN
 CREATE TABLE
 ALTER TABLE
                        addgeometrycolumn
 ----------------------------------------------------------------
  public.water_polygons.geom SRID:3857 TYPE:MULTIPOLYGON DIMS:2
 (1 row)

 ERROR:  invalid input syntax for type double precision: "    [shp2pgsql-
 core.c:FindPolygons:441] FindPolygons[0]: allocated space for 6 rings"
 CONTEXT:  COPY water_polygons, line 1, column fid: "    [shp2pgsql-
 core.c:FindPolygons:441] FindPolygons[0]: allocated space for 6 rings"
 ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 ROLLBACK
 ERROR:  relation "water_polygons" does not exist

 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3662>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.