[postgis-users] bmd.hasnodata does not exist

[Andreas Forø Tollefsen]

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 <bkpark at 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
> <andreasft at 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 <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
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
>
>
> --
> Bborie Park
> Programmer
> Center for Vectorborne Diseases
> UC Davis
> 530-752-8380
> bkpark at ucdavis.edu
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111130/147ef441/attachment.html>