[postgis-users] bmd.hasnodata does not exist

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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 <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/20111201/d264032f/attachment.html>