[postgis-tickets] [PostGIS] #3008: pgsql2shp version 2.1.4 crash

[PostGIS]

#3008: pgsql2shp version 2.1.4 crash
-----------------------+----------------------------------------------------
 Reporter:  nap2000    |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.1.5
Component:  postgis    |     Version:  2.1.x        
 Keywords:  pgsql2shp  |  
-----------------------+----------------------------------------------------
 As far as I know nothing has changed on my side since pgsql2shp version
 2.1.3 which worked.

 The crash file is attached.   The first few lines of which are:

 ProblemType: Crash
 Architecture: amd64
 CrashCounter: 1
 Date: Wed Dec 17 00:17:01 2014
 DistroRelease: Ubuntu 14.04
 ExecutablePath: /usr/bin/pgsql2shp
 ExecutableTimestamp: 1412113909
 ProcCmdline: pgsql2shp -f /smap/temp/78f455c7-5166-4e9b-
 b3c2-9aa9633a82c6/s1_main -u ws -P ws1234 results select\ s1_main.prikey\
 as\ prikey,s1_main._user\ as\ xuser,s1_main._version\ as\
 xversion,s1_main._device\ as\ xdevice,to_char(s1_main._start,\ 'YYYY-MM-
 DD\ HH24:MI:SS')\ as\ xstart,to_char(s1_main._end,\ 'YYYY-MM-DD\
 HH24:MI:SS')\ as\ xend,s1_main.name\ as\ name,s1_main.found\ as\
 found,s1_main.street_number\ as\ street_number,s1_main.street_name\ as\
 street_name,s1_main.suburb_town\ as\ suburb_town,s1_main.site_name\ as\
 site_name,s1_main.location\ as\ location,s1_main.location_other\ as\
 location_other,s1_main.incident\ as\ incident,s1_main.class\ as\
 class,s1_main.hotshots\ as\ hotshots,'https://prea.smap.com.au/'\ ||\
 s1_main.hotshot_image\ as\ hotshot_image,s1_main.risk\ as\
 risk,s1_main.risk_description\ as\ risk_description,s1_main.waste_bins\
 as\ waste_bins,s1_main.recycling_bins\ as\
 recycling_bins,s1_main.butt_bins\ as\
 butt_bins,s1_main.bins__bins_overflowing\ as\
 bins__bins_overflowing,s1_main.bins__bins_repair\ as\
 bins__bins_repair,s1_main.bins__bins_signage\ as\
 bins__bins_signage,s1_main.source__passing_vehicles\ as\
 source__passing_vehicles,s1_main.source__passing_pedestrians\ as\
 source__passing_pedestrians,s1_main.source__gathering_points_seats\ as\
 source__gathering_points_seats,s1_main.source__schools\ as\
 source__schools,s1_main.source__bank_atm\ as\
 source__bank_atm,s1_main.source__transport_stop\ as\
 source__transport_stop,s1_main.source__retail\ as\
 source__retail,s1_main.source__food_outlets\ as\
 source__food_outlets,s1_main.source__outdoor_event\ as\
 source__outdoor_event,s1_main.source__tourist_site\ as\
 source__tourist_site,s1_main.source__weather\ as\
 source__weather,s1_main.source__other\ as\
 source__other,s1_main.source_other\ as\ source_other,s1_main.green_waste\
 as\ green_waste,s1_main.building_waste\ as\
 building_waste,s1_main.soils_fill\ as\ soils_fill,s1_main.general_other\
 as\ general_other,s1_main.asbestos\ as\ asbestos,s1_main.other_material\
 as\ other_material,s1_main.mattresses\ as\ mattresses,s1_main.furniture\
 as\ furniture,s1_main.whitegoods\ as\ whitegoods,s1_main.tyres\ as\
 tyres,s1_main.ewaste\ as\ ewaste,s1_main.car_bodies\ as\
 car_bodies,s1_main.evidence\ as\ evidence,s1_main.comments\ as\
 comments,s1_main.investigation\ as\ investigation,s1_main.cleanup\ as\
 cleanup,s1_main.cleanup_other\ as\ cleanup_other,s1_main.the_geom\ as\
 the_geom\ from\ s1_main\ where\ s1_main._bad='false'
 ProcCwd: /var/lib/tomcat7

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