[postgis-users] bmd.hasnodata does not exist

[Andreas Forø Tollefsen]

No one else had the same issue with 8242? This is exactly the same query as
i ran in r.8001, but now it give me the error below in return.
Any suggestions?

Best,
Andreas

2011/11/25 Andreas Forø Tollefsen <andreasft at gmail.com>

> Hi,
>
> Sorry for posting a lot these days but I am very busy finalizing a project.
>
> Previously, I have been running the following query without problems (in
> rev.8001). After updating to rev.8242 i am getting a strange error.
> Could someone please see what is wrong? Is it one of the functions that
> has changed?
>
> Query:
> SELECT gid, AVG(((foo.geomval).val)) FROM (SELECT p.gid,
> ST_Intersection(p.cell, r.rast) AS geomval FROM mountain r, priogrid_land p
> WHERE ST_Intersects(p.cell, r.rast) AND p.gid =219260) AS foo
> GROUP BY gid ORDER BY gid;
>
> Error:
> ERROR:  column bmd.hasnodata does not exist
> LINE 1: SELECT bmd.hasnodata                FROM ST_BandMetaData(ras...
>                ^
> QUERY:  SELECT bmd.hasnodata                FROM ST_BandMetaData(rast,
> nband) AS bmd
> CONTEXT:  PL/pgSQL function "_st_intersects" line 32 at SQL statement
> PL/pgSQL function "st_intersection" line 5 at assignment
>
> ********** Error **********
>
> ERROR: column bmd.hasnodata does not exist
> SQL state: 42703
> Context: PL/pgSQL function "_st_intersects" line 32 at SQL statement
> PL/pgSQL function "st_intersection" line 5 at assignment
>
>
> Thanks for any help.
>
> Best regards,
> Andreas
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111129/dc0c608b/attachment.html>