[mapserver-users] Postgis Error

[Rahkonen Jukka]

Hi,
 
Have you also registered the view in geometry_columns?
 
-Jukka Rahkonen-


________________________________

	Lähettäjä: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] Puolesta Aaron Hunt
	Lähetetty: 27. toukokuuta 2008 14:25
	Vastaanottaja: mapserver-users at lists.osgeo.org
	Aihe: [mapserver-users] Postgis Error
	
	
	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/42710d81/attachment-0001.html