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

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to