[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.6
Component:  postgis    |     Version:  2.1.x        
 Keywords:  pgsql2shp  |  
-----------------------+----------------------------------------------------

Comment(by nap2000):

 Hi Robe,

 I was wrong when I said the problem occurred with a new postgis version.
 Its the specific query and as you can see below it looks like postgis
 2.1.2.

 1) select postgis_full_version() || ' ' || version();
 POSTGIS="2.1.2 r12389" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1"
 LIBJSON="UNKNOWN" RASTER PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu,
 compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit
 (1 row)

 2) If I remove arbitrary columns from the query then the crash does not
 happen.  However it does not appear to be a specific column that is
 causing it.   I am attaching a file with the full query that crashes and a
 smaller query that does not.

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