<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16437"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff face=Arial><FONT size=2><FONT
face=Tahoma><FONT color=#000000>Andreas <SPAN
class=843034308-01122011>,</SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff face=Arial><SPAN
class=843034308-01122011></SPAN><SPAN class=843034308-01122011></SPAN><FONT
size=2><FONT face=Tahoma><FONT color=#000000>Y<SPAN class=843034308-01122011>ou
don't need to install postgis.sql,
rtpostgis.sql</SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial><FONT size=2><FONT face=Tahoma><FONT
color=#000000><SPAN
class=843034308-01122011></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial><FONT size=2><FONT face=Tahoma><FONT
color=#000000><SPAN class=843034308-01122011>Just _upgrade_20_minor.sql
ones.</SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial><FONT size=2><FONT face=Tahoma><FONT
color=#000000><SPAN
class=843034308-01122011></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial><FONT size=2><FONT face=Tahoma><FONT
color=#000000><SPAN class=843034308-01122011>That is unless we change the on
disk format or change non-droppable things like casts which we might before
release.</SPAN></FONT></FONT></DIV>
<DIV dir=ltr align=left><BR></DIV></FONT></FONT><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Andreas Forø Tollefsen<BR><B>Sent:</B> Wednesday, November 30, 2011 12:30
PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re:
[postgis-users] bmd.hasnodata does not exist<BR></FONT><BR></DIV>
<DIV></DIV>Thanks!
<DIV><BR></DIV>
<DIV>After updating to latest revision i only ran:
<DIV>psql -d database -f postgis.sql</DIV>
<DIV>psql -d database -f rtpostgis.sql</DIV>
<DIV><BR></DIV>
<DIV>I was not aware that i had to do the _upgrade_20_minor.sql as well.</DIV>
<DIV><BR></DIV>
<DIV>Now it works.</DIV>
<DIV><BR></DIV>
<DIV>Andreas<BR><BR>
<DIV class=gmail_quote>2011/11/30 Bborie Park <SPAN dir=ltr><<A
href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</A>></SPAN><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>Andreas,<BR><BR>Though you upgraded the underlying
library, did you run<BR>rtpostgis_upgrade_20_minor.sql? Something is
definitely out of sync.<BR><BR>-bborie<BR>
<DIV>
<DIV></DIV>
<DIV class=h5><BR>On Tue, Nov 29, 2011 at 12:58 AM, Andreas Forø
Tollefsen<BR><<A
href="mailto:andreasft@gmail.com">andreasft@gmail.com</A>> wrote:<BR>>
No one else had the same issue with 8242? This is exactly the same query
as<BR>> i ran in r.8001, but now it give me the error below in
return.<BR>> Any suggestions?<BR>> Best,<BR>>
Andreas<BR>><BR>> 2011/11/25 Andreas Forø Tollefsen <<A
href="mailto:andreasft@gmail.com">andreasft@gmail.com</A>><BR>>><BR>>>
Hi,<BR>>> Sorry for posting a lot these days but I am very busy
finalizing a<BR>>> project.<BR>>> Previously, I have been
running the following query without problems (in<BR>>> rev.8001).
After updating to rev.8242 i am getting a strange error.<BR>>> Could
someone please see what is wrong? Is it one of the functions
that<BR>>> has changed?<BR>>> Query:<BR>>> SELECT gid,
AVG(((foo.geomval).val)) FROM (SELECT p.gid,<BR>>>
ST_Intersection(p.cell, r.rast) AS geomval FROM mountain r, priogrid_land
p<BR>>> WHERE ST_Intersects(p.cell, r.rast) AND p.gid =219260) AS
foo<BR>>> GROUP BY gid ORDER BY gid;<BR>>> Error:<BR>>>
ERROR: column bmd.hasnodata does not exist<BR>>> LINE 1: SELECT
bmd.hasnodata FROM
ST_BandMetaData(ras...<BR>>>
^<BR>>> QUERY: SELECT bmd.hasnodata
FROM
ST_BandMetaData(rast,<BR>>> nband) AS bmd<BR>>> CONTEXT:
PL/pgSQL function "_st_intersects" line 32 at SQL
statement<BR>>> PL/pgSQL function "st_intersection" line 5 at
assignment<BR>>> ********** Error **********<BR>>> ERROR: column
bmd.hasnodata does not exist<BR>>> SQL state: 42703<BR>>>
Context: PL/pgSQL function "_st_intersects" line 32 at SQL
statement<BR>>> PL/pgSQL function "st_intersection" line 5 at
assignment<BR>>><BR>>> Thanks for any help.<BR>>> Best
regards,<BR>>> Andreas<BR>><BR></DIV></DIV>
<DIV class=im>> _______________________________________________<BR>>
postgis-users mailing list<BR>> <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>>
<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>><BR>><BR><BR><BR><BR></DIV><FONT
color=#888888>--<BR>Bborie Park<BR>Programmer<BR>Center for Vectorborne
Diseases<BR>UC Davis<BR><A href="tel:530-752-8380"
value="+15307528380">530-752-8380</A><BR><A
href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</A><BR></FONT>
<DIV>
<DIV></DIV>
<DIV
class=h5>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV></DIV></BLOCKQUOTE></BODY></HTML>