[postgis-devel] [PostGIS] #1008: Too many columns in select crashes pgsql2shp

[PostGIS]

#1008: Too many columns in select crashes pgsql2shp
---------------------------+------------------------------------------------
 Reporter:  joshjordan     |       Owner:  mcayland     
     Type:  defect         |      Status:  new          
 Priority:  medium         |   Milestone:  PostGIS 2.0.0
Component:  loader/dumper  |     Version:  trunk        
 Keywords:  pgsql2shp      |  
---------------------------+------------------------------------------------
 This select statement works if I take out half of the columns in it.  It
 doesn't matter which half so it is not a specific column that causes the
 crash.

 Versions:
  2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
  PostgreSQL 8.4.8 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.5.real
 (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 64-bit

 pgsql2shp -f /var/www/currentmap/joshj/nationwide_county -u postgres
 -P..... -p 5432 smartmaps "select distinct a.geom,a.gid, a.id, a.shporder,
 a.area, a.county, a.fullname, a.name, a.state, a.type, a.county_sea,
 a.population, a.male, a.female, a.age_5, a.age_5_to_9, a.age_10_to_,
 a.age_15_to_, a.age_20_to_, a.age_25_to_, a.age_35_to_, a.age_45_to_,
 a.age_55_to_, a.age_60_to_, a.age_65_to_, a.age_75_to_, a.age_85,
 a.median_age, a.age_18, a.male_18, a.female_18, a.age_21, a.age_62,
 a.age_65, a.male_65, a.female_65, a.f1_race, a.white, a.black, a.amindian,
 a.asian, a.asn_asian_, a.asn_chines, a.asn_filipi, a.asn_japane,
 a.asn_korean, a.asn_vietna, a.asn_other, a.hawaiian, a.hwn_native,
 a.hwn_guaman, a.hwn_samoan, a.hwn_other_, a.other_race, a.f2_races,
 a.ap_white, a.ap_black, a.ap_amindia, a.ap_asian, a.ap_hawaiia,
 a.ap_other, a.ap_hispani, a.h_ap_mexic, a.h_ap_puert, a.h_ap_cuban,
 a.h_ap_other, a.not_hispan, a.nh_white, a.in_househo, a.inhh_house,
 a.inhh_spous, a.inhh_child, a.inhh_own, a.inhh_other, a.inhh_othe1,
 a.inhh_nonre, a.inhh_unmar, a.in_group, a.ingrp_inst, a.ingrp_noni,
 a.households, a.hh_family, a.hh_family_, a.hh_family1, a.hh_fam_mar,
 a.hh_female_, a.hh_female1, a.hh_nonfami, a.hh_non_liv, a.hh_non_alo,
 a.hh_people_, a.hh_people1, a.average_hh, a.average_fa, a.housing_un,
 a.hu_occupie, a.hu_vacant, a.vachu_for_, a.owner_vaca, a.rental_vac,
 a.occhu_owne, a.occhu_rent, a.occhu_own_, a.occhu_ren1, a.in_school_,
 a.in_sch_nur, a.in_sch_kin, a.in_sch_ele, a.in_sch_hig, a.in_sch_col,
 a.populatio1, a.f25_9th_gr, a.f25_9th_to, a.f25_high_s, a.f25_some_c,
 a.f25_associ, a.f25_bachel, a.f25_grad_o, a.f25__hs_gr, a.f25__bache,
 a.populatio2, a.f15_never_, a.f15_now_ma, a.f15_separa, a.f15_widowe,
 a.f15_widow1, a.f15_divorc, a.f15_divor1, a.grandparen, a.grandpare1,
 a.civilian, a.civilian2, a.populatio3, a.f520_wdisa, a.populatio4,
 a.f2164_wdis, a.f2164_wdi1, a.f2164_no_d, a.f2164_no_1, a.populatio5,
 a.f65_wdisab, a.populatio6, a.f5_same_ho, a.f5_differe, a.f5_diff_hs,
 a.f5_diff_h1, a.f5_diff_h2, a.f5_diff_h3, a.f5_elsewhe, a.native,
 a.native_bor, a.native_bo1, a.native_bo2, a.native_bo3, a.foreign_en,
 a.foreign_na, a.foreign_no, a.foreign_bo, a.foreign_eu, a.foreign_as,
 a.foreign_af, a.foreign_oc, a.foreign_la, a.foreign_n1, a.f5_english,
 a.f5_other_l, a.f5_other_1, a.f5_other_2, a.f5_other_3, a.f5_other_i,
 a.f5_other_4, a.f5_other_5, a.f5_other_6, a.total_ance, a.ancestry_a,
 a.ancestry_c, a.ancestry_d, a.ancestry_1, a.ancestry_e, a.ancestry_f,
 a.ancestry_2, a.ancestry_g, a.ancestry_3, a.ancestry_h, a.ancestry_i,
 a.ancestry_4, a.ancestry_l, a.ancestry_n, a.ancestry_p, a.ancestry_5,
 a.ancestry_r, a.ancestry_s, a.ancestry_6, a.ancestry_7, a.ancestry_8,
 a.ancestry_9, a.ancestry10, a.ancestry_u, a.ancestry11, a.ancestry_w,
 a.ancestry12, a.ancestry_o, a.populatio7, a.f16_in_lab, a.f16_in_lf_,
 a.f16_in_lf1, a.f16_in_lf2, a.f16_in_lf3, a.f16_in_lf4, a.f16_not_in,
 a.females_16, a.fem_16_in_, a.fem_16_in1, a.fem_16_in2, a.own_childr,
 a.own_child6, a.workers_16, a.f16_mode_c, a.f16_mode_1, a.f16_mode_p,
 a.f16_mode_w, a.f16_mode_o, a.f16_mode_2, a.f16_mean_t, a.employed_c,
 a.ec_16_occ_, a.ec_16_occ1, a.ec_16_occ2, a.ec_16_occ3, a.ec_16_occ4,
 a.ec_16_occ5, a.ec_16_ind_, a.ec_16_ind1, a.ec_16_ind2, a.ec_16_ind3,
 a.ec_16_ind4, a.ec_16_ind5, a.ec_16_ind6, a.ec_16_ind7, a.ec_16_ind8,
 a.ec_16_ind9, a.ec_16_in10, a.ec_16_in11, a.ec_16_in12, a.ec_16_work,
 a.ec_16_wor1, a.ec_16_wor2, a.ec_16_wor3, a.household1, a.hh_income_,
 a.clon, a.clat, a.tv_hhs, a.cable_hhs, a.akhi_clat, a.akhi_clon from
 nationwide_county a where a.gid in (select distinct layergid from
 nationwide_county_matches where extent = 'Nationwide_DMA' and extentgid =
 5)"

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