[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      |  
---------------------------+------------------------------------------------

Comment(by joshjordan):

 That is a lot of added complexity to add a restriction of 254 fields.  The
 dbf file format has only a total record length limit, you may have over
 255 fields as long as all of the field lengths add up to less than 2^16.
 There is no other point in the postgis/mapserver stack where 255 fields is
 the limit, so this change will break things for some people.  If you want
 to make this dynamically allocated, make the buffer the size of the input
 string.  We are just talking about 8kb that is only temporarily used and
 then taken out of scope.

 This issue can be put to rest by changing the 2kb static buffer to 8kb.

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