Andreas, Though you upgraded the underlying library, did you run rtpostgis_upgrade_20_minor.sql? Something is definitely out of sync.
-bborie On Tue, Nov 29, 2011 at 12:58 AM, Andreas Forø Tollefsen <andrea...@gmail.com> wrote: > 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 > > -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
