[postgis-tickets] [PostGIS] #4994: shp2pgsql is sometimes missing the INSERT statements

[PostGIS]

#4994: shp2pgsql is sometimes missing the INSERT statements
---------------------+---------------------------
 Reporter:  myon     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.1.5
Component:  postgis  |    Version:  2.5.x
 Keywords:           |
---------------------+---------------------------
 I've been chasing regression tests failures seen in 3.2 on Debian
 unstable:
 https://pgdgbuild.dus.dg-i.net/view/Binaries/job/postgis-
 binaries/326/architecture=amd64,distribution=sid/console
 The sympton is always that the diff shows some rows missing.

 I managed to track it down to shp2pgsql sometimes missing the INSERT part;
 running it in a loop will eventually trigger the bug.

 {{{
 while ./loader/shp2pgsql -G  -g the_geom ./regress/loader/MultiPointZ.shp
 loadedshp | grep INSERT; do :; done
 ...
 Shapefile type: MultiPointZ
 Postgis type: MULTIPOINT[4]
 INSERT INTO "loadedshp" (the_geom) VALUES
 ('01040000E0E61000000300000001010000C00000000000000000000000000000F03F0000000000000040000000000000084001010000C00000000000002240000000000000F0BF00000000000000C000000000000008C001010000C00000000000002240000000000000F0BF00000000000034C00000000000C05EC0');
 Shapefile type: MultiPointZ
 Postgis type: MULTIPOINT[4]
 INSERT INTO "loadedshp" (the_geom) VALUES
 ('01040000E0E61000000300000001010000C00000000000000000000000000000F03F0000000000000040000000000000084001010000C00000000000002240000000000000F0BF00000000000000C000000000000008C001010000C00000000000002240000000000000F0BF00000000000034C00000000000C05EC0');
 Shapefile type: MultiPointZ
 Postgis type: MULTIPOINT[4]
   <-- no INSERT here
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4994>
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.