[mapserver-users] Postgis Error

[Obe, Regina]

Aaron,
 
Actually I don't think you need it in the geometry_columns if you spell out the whole USING UNIQUE bit.
 
What exactly does your data layer look like  - all I see is
 
Data ""
 
Which can't be right.  
 
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
 
Dumb questions - 
 
you are absolutely sure you are connecting to the same database.
Your table is in the default schema or you have the schema spelled out in your Mapserver data layer.
 
Hope that helps,
Regina

________________________________

From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Rahkonen Jukka
Sent: Tuesday, May 27, 2008 7:28 AM
To: Aaron Hunt; mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] Postgis Error


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 



-----------------------------------------
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080527/e0579e2b/attachment.htm>