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 <andrea...@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 >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
