Andreas, You'll probably want to run rtpostgis_upgrade_20_minor.sql every time you sync up your copy of postgis-trunk.
-bborie On Wed, Nov 30, 2011 at 9:29 AM, Andreas Forø Tollefsen <andrea...@gmail.com> wrote: > 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 <bkp...@ucdavis.edu> >> >> 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 > > > _______________________________________________ > 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
