<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=664322711-27052008>Hi,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=664322711-27052008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=664322711-27052008>Have you also registered the view in
geometry_columns?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=664322711-27052008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=664322711-27052008>-Jukka Rahkonen-</SPAN></FONT></DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=fi dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Lähettäjä:</B>
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <B>Puolesta </B>Aaron
Hunt<BR><B>Lähetetty:</B> 27. toukokuuta 2008 14:25<BR><B>Vastaanottaja:</B>
mapserver-users@lists.osgeo.org<BR><B>Aihe:</B> [mapserver-users] Postgis
Error<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>I have been tring to get a script working on my new server and I get the
following error.</DIV>
<DIV> </DIV>
<DIV>"Postgresql reports the error as 'ERROR: relation "row_crop_boundary"
does not exist '" </DIV>
<DIV> </DIV>
<DIV>row_crop_boundary is a view contaning the geom column. There are no
uppercaes names and if I log into the command line it works fine. Does anyone
have any ideas? The layer def is below (I seet the data and filter in
code).</DIV>
<DIV> </DIV>
<DIV>Thanks<BR clear=all></DIV>
<DIV>LAYER # Red Field<BR>
TYPE
polygon<BR> CONNECTIONTYPE
postgis<BR>
NAME
RedFields<BR> CONNECTION
"user=xxxpassword=xxx dbname=xxx host=localhost
port=5432"<BR>
DATA
""<BR>
FILTER
""<BR>
STATUS
ON<BR>
DEBUG
ON<BR> TRANSPARENCY
30<BR> LABELITEM
field_name<BR> CLASS<BR> COLOR 255 0
0<BR> OUTLINECOLOR 0 0 0<BR> LABEL<BR> ANTIALIAS
TRUE<BR> FORCE
TRUE<BR> POSITION CC<BR> BACKGROUNDCOLOR 75
75 75<BR> COLOR 255 255 255<BR> BUFFER
1<BR> END<BR> END<BR>
PROJECTION<BR> "init=epsg:4326" #NAD83 UTM zone
10N<BR> END<BR> END</DIV>
<DIV><BR>-- <BR>Aaron D. Hunt </DIV></BLOCKQUOTE></BODY></HTML>