[postgis-users] ST_Intersection Raster error

[Bborie Park]

On Tue, Oct 11, 2011 at 11:29 PM, Sandro Santilli <strk at keybit.net> wrote:
> On Tue, Oct 11, 2011 at 06:59:27PM -0600, joel brown wrote:
>> Hi all, I am just starting to experiment with postgis 2.0 and its raster
>> support.   When I run the following query:
>>
>> select st_intersection(r.rast, v.geom)
>> from ned r, test_line v
>> where st_intersects(r.rast, v.geom)
>>
>> I get this error:
>>
>> ERROR:  lower bound of FOR loop cannot be null
>> CONTEXT:  PL/pgSQL function "_st_intersects" line 103 at FOR with integer
>> loop variable
>> PL/pgSQL function "st_intersection" line 4 at assignment
>> SQL function "st_intersection" statement 1
>>
>> My build is SVN revision 7959.  The ned table consists of about 1800 100x100
>> tiles.  The test_line table contains one record with a linestring geometry.
>>  Both the tiles and the linestring are in the same projection (EPSG 4326).
>>
>> Does anyone have any insights into what might be going on here?
>
> It's a bug, it will help if you file it on http://trac.osgeo.org/postgis
> (raster category)
>
> --strk;
>
>  ()   Free GIS & Flash consultant/developer
>  /\   http://strk.keybit.net/services.html
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

Can you try r7975.  I believe I've resolved the problem.

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu