WFS requests ignore PostGIS columns beside the Geometry and ID column

[sg1]

Hi everybody,

i extracted ArcGIS feature classes to shapefiles and imported them into a
PostGIS database.

Then i formulated a simple WMS request - everything worked fine.

Then I tried setting up a WFS request. I got some results, but somehow the
result ignored every column but the gid and the_geom!
actually the getcapabilities return no errors and also the getfeature
returns with no errors, just the column attributes are missing!

Up to now there's just one more column,that should be integrated too. It is
called 'wegnr' - type is 'character varying' 

The interesting thing is, that the column is also missing when I use the
Shapefile as data source.
Schema, ns are default.
Usually the column should be described by another <element /> tab, but it's
missing

I can't find the error.
As I can access the data in the database I thought it's a mapserver problem,
but I'm not sure

The describeFeatureType request looks as followed: 

#################################################################
<schema targetNamespace="http://mapserver.gis.umn.edu/mapserver"
elementFormDefault="qualified" version="0.1">
<import namespace="http://www.opengis.net/gml"
schemaLocation="http://schemas.opengis.net/gml/2.1.2/feature.xsd"/>
<element name="wanderwege" type="ms:wanderwegeType"
substitutionGroup="gml:_Feature"/>
−	<complexType name="wanderwegeType">
−	<complexContent>
−	<extension base="gml:AbstractFeatureType">
−	<sequence>
<element name="msGeometry" type="gml:GeometryPropertyType" minOccurs="0"
maxOccurs="1"/>
</sequence>
</extension>
</complexContent>
</complexType>
<element name="wanderwege_shp" type="ms:wanderwege_shpType"
substitutionGroup="gml:_Feature"/>
−	<complexType name="wanderwege_shpType">
−	<complexContent>
−	<extension base="gml:AbstractFeatureType">
−	<sequence>
<element name="msGeometry" type="gml:GeometryPropertyType" minOccurs="0"
maxOccurs="1"/>
</sequence>
</extension>
</complexContent>
</complexType>
</schema>

###################################################
That's an extract of the layer in the Mapfile:

LAYER 
	NAME 'wanderwege'
	TYPE LINE
	CONNECTION 'user=postgres password=Si18JaudcTdW. dbname=postgis
host=localhost port=5432'
	CONNECTIONTYPE POSTGIS
	DATA 'the_geom from wanderwege'
DUMP TRUE
	STATUS OFF
	METADATA 
		'wms_title' 'wanderwege'
		'wms_srs' 'EPSG:31285'		
		'wms_title' 'ww'
               	'wfs_title' 'ww'
		'wfs_typename' 'ww'
		'wfs_request_method' 'get'
		'wfs_service' 'wfs'
		'wfs_version' '1.0.0'
		'wfs_extent' '392570 145627 578166 218654'
		'wfs_featureid' 'gid'
		'wfs_tname' 'wegnr'
		'wfs_srs' 'EPSG:31285'
		'gml_include_items' 'all '	
	END
END
##########################################

Thanks for every idea you guys have, I'm quite at my wits' end

sg1

-- 
View this message in context: http://www.nabble.com/WFS-requests-ignore-PostGIS-columns-beside-the-Geometry-and-ID-column-tp14766031p14766031.html
Sent from the Mapserver - User mailing list archive at Nabble.com.