id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc 4994,shp2pgsql is sometimes missing the INSERT statements,myon,robe,"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 }}}",defect,closed,blocker,PostGIS 3.1.5,utils/loader-dumper,2.5.x -- EOL,fixed,,Bas Couwenberg pramsey