<!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.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>Aaron,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>Actually I don't think you need it in the geometry_columns
if you spell out the whole USING UNIQUE bit.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>What exactly does your data layer look like - all I
see is</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>Data ""</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>Which can't be right. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>Are you using the same account in Mapserver as you are
using in your command line. Although permission problems usually give an
access denied not a relation does not exist</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>Dumb questions - </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>you are absolutely sure you are connecting to the same
database.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>Your table is in the default schema or you have the schema
spelled out in your Mapserver data layer.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=863001212-27052008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Rahkonen
Jukka<BR><B>Sent:</B> Tuesday, May 27, 2008 7:28 AM<BR><B>To:</B> Aaron Hunt;
mapserver-users@lists.osgeo.org<BR><B>Subject:</B> Re: [mapserver-users] Postgis
Error<BR></FONT><BR></DIV>
<DIV></DIV>
<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>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>