One guess: You have a old version of ST_Intersects()...
Drop all the variant and redefine them with the ones in rtpostgis.sql... Pierre > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Andreas Forø Tollefsen > Sent: Tuesday, November 29, 2011 3:58 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] bmd.hasnodata does not exist > > 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
