Andreas , You don't need to install postgis.sql, rtpostgis.sql Just _upgrade_20_minor.sql ones. That is unless we change the on disk format or change non-droppable things like casts which we might before release.
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Andreas Forø Tollefsen Sent: Wednesday, November 30, 2011 12:30 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] bmd.hasnodata does not exist 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
