[postgis-users] bmd.hasnodata does not exist

[Pierre Racine]

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-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at 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 <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
>