[postgis-users] ST_Intersects Error

[elliott]

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

On 11/1/2011 1:06 PM, Bborie Park wrote:
> On 11/01/2011 08:50 AM, elliott wrote:
>> Thanks for the response. I have upgraded to PostGIS r8074 and restarted
>> the database but still having the same problem.
>>
>
> When you upgraded, did you upgrade the sql functions as well?  I 
> believe there is an upgrade script (rtpostgis_upgrade_20_minor.sql) 
> that you'll want to run.  If you only upgraded the backend, that won't 
> resolve your problem as that error comes from a pure plpgsql function.
>
> -bborie