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