[postgis-users] bmd.hasnodata does not exist

[Bborie Park]

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
<andreasft at 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 <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
>
>
> _______________________________________________
> 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