[postgis-users] ST_Intersects Error

Bborie Park bkpark at ucdavis.edu
Tue Nov 1 11:20:12 PDT 2011


On 11/01/2011 10:32 AM, elliott wrote:
> No, I had not updated the sql functions. With that update, I am now
> getting a different error:
>
> select ST_Value(rast, ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5),
> 4326), ST_SRID(rast))) from srtm3 where ST_Intersects(rast, 1,
> ST_Transform(ST_SetSRID(ST_Point(126.5, 37.5), 4326), ST_SRID(rast)));
> ERROR: function st_asraster(geometry, double precision, double
> precision) is not unique at character 8
> HINT: Could not choose a best candidate function. You might need to add
> explicit type casts.
> QUERY: SELECT ST_AsRaster(geom, scale, scale)
> CONTEXT: PL/pgSQL function "_st_intersects" line 14 at assignment
> SQL function "st_intersects" statement 1
>

Interesting.  Can you try r8077?  I've made a tweak that should 
eliminate the error.  What version of PostgreSQL are you running?  I 
haven't seen this error with 8.4, 9.0 or 9.1 in Linux.

-bborie

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



More information about the postgis-users mailing list