[postgis-tickets] [PostGIS] #2332: ST_GeomFromWKB crashes PostgreSQL server

[PostGIS]

#2332: ST_GeomFromWKB crashes PostgreSQL server
---------------------+------------------------------------------------------
 Reporter:  dbaston  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  blocker  |   Milestone:  PostGIS 2.0.4
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------
Changes (by robe):

  * priority:  medium => blocker
  * milestone:  PostGIS 2.1.0 => PostGIS 2.0.4


Comment:

 {{{
 SELECT
 ST_GeomFromWKB('0104000020E61000000100000001010000008812F4177AE557C040745E6397943D40'::bytea)
 }}}


 Crashes on my 9.2.4 windows 2008 x64 on my PostGIS 2.1.0beta2 as well, I
 have to check on my PostgreSQL 9.3 beta 64bit beta install, but I suspect
 its fine on that.

 {{{
 POSTGIS="2.1.0beta2 r11441" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel.
 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24"
 LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER PostgreSQL 9.2.4, compiled by
 Visual C++ build 1600, 64-bit
 }}}


 I suspect its how we are throwing errors from c code or something about
 how the PostgreSQL 9.2 VC builds are compiled.

 Try changing your function definition to this:

 {{{
 CREATE OR REPLACE FUNCTION st_geomfromwkb(bytea)
   RETURNS geometry AS
 '$libdir/postgis-2.0', 'LWGEOM_from_WKB'
   LANGUAGE c STRICT
   COST 1;

 }}}

 Essentially taking out the IMMUTABLE from the definition.  That fixes it
 for me.

 I think this is the same issue as #2185

 Which I'm still hunting down the cause.

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