id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc
659,shp2pgsql crashing when trying to load into geography order sensitive,robe,pramsey,"I have this statement

{{{
shp2pgsql -G -g geog data/roadtrl020.shp ch01.roads_geog > roads_geog.sql
}}}

works fine with the PostGIS 1.5 shp2pgsql but crashes with my current build of PostGIS 2.0 shp2pgsql loader.  Loading without the -G switch works fine too in both and shp2pgsql-gui also works fine in both.

Actually loading like this also works:
{{{
shp2pgsql -g geog -G data/roadtrl020.shp ch01.roads_geog > roads_geog.sql
}}}

So it seems to be sensitive to the order of the arguments
My build is (running on windows 7)
{{{
RCSID: $Id: shp2pgsql-core.h 6008 2010-09-22 23:45:35Z mleslie $ RELEASE: 2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
USAGE: shp2pgsql [<options>] <shapefile> [<schema>.]<table>
}}}




",defect,closed,medium,PostGIS 2.0.0,postgis,trunk,fixed,,