Thanks! After updating to latest revision i only ran: psql -d database -f postgis.sql psql -d database -f rtpostgis.sql
I was not aware that i had to do the _upgrade_20_minor.sql as well. Now it works. Andreas 2011/11/30 Bborie Park <[email protected]> > 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 > <[email protected]> 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 <[email protected]> > >> > >> 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 > > [email protected] > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > > > -- > Bborie Park > Programmer > Center for Vectorborne Diseases > UC Davis > 530-752-8380 > [email protected] > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
