[mapserver-users] Postgis Error

[Aaron Hunt]

I have been tring to get a script working on my new server and I get the
following error.

"Postgresql reports the error as 'ERROR: relation "row_crop_boundary" does
not exist '"

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).

Thanks
LAYER # Red Field
     TYPE           polygon
     CONNECTIONTYPE postgis
     NAME          RedFields
     CONNECTION    "user=xxxpassword=xxx dbname=xxx host=localhost
port=5432"
     DATA          ""
     FILTER        ""
     STATUS        ON
     DEBUG         ON
     TRANSPARENCY  30
     LABELITEM field_name
     CLASS
 COLOR 255 0 0
 OUTLINECOLOR 0 0 0
 LABEL
  ANTIALIAS  TRUE
  FORCE    TRUE
  POSITION   CC
  BACKGROUNDCOLOR 75 75 75
  COLOR 255 255 255
  BUFFER 1
 END
     END
    PROJECTION
      "init=epsg:4326" #NAD83 UTM zone 10N
    END
  END

-- 
Aaron D. Hunt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080527/d2fed3ae/attachment.htm>