shp2pgsql does not work in debug mode

[komzpa]

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

[strk]

I guess the fix would be making sure all debug prints go to stderr ?

[komzpa]

If someone needs a workaround:

shp2pgsql ... | grep -v "\[" | grep -v '^\s*$$' |  psql

[pramsey]

All notice/debug messages on stderr at r15652 in trunk