[postgis-devel] [PostGIS] #1061: [raster] Using a CTE causes process to fail

PostGIS trac at osgeo.org
Fri Jun 24 14:36:33 PDT 2011


#1061: [raster] Using a CTE causes process to fail
----------------------------+-----------------------------------------------
 Reporter:  dustymugs       |       Owner:  pracine      
     Type:  defect          |      Status:  new          
 Priority:  blocker         |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 The following query causes the postgresql process to abort.

 {{{
 WITH foo AS (
         SELECT
                 ST_AddBand(
                         ST_MakeEmptyRaster(10, 10, 10, 10, 2, 2, 0, 0,-1)
                         , 1, '64BF', 0, 0
                 )
         AS rast
 )
 SELECT rast FROM foo
 }}}

 The crash relates to the ST_AddBand as the following does not cause an
 abort.

 {{{
 WITH foo AS (
         SELECT
                 ST_MakeEmptyRaster(10, 10, 10, 10, 2, 2, 0, 0,-1)
         AS rast
 )
 SELECT rast FROM foo
 }}}

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


More information about the postgis-devel mailing list