What version of MapServer are you using? As well, I see that you have set 'gml_include_items' to 'all '. If you remove the trailing space (i.e. 'all'), does that help?
Failing this, I suggest you submit a testcase offline (minimal mapfile/sample data), which I can help you with. ..Tom > -----Original Message----- > From: UMN MapServer Users List > [mailto:[EMAIL PROTECTED] On Behalf Of sg1 > Sent: 12 January, 2008 5:30 AM > To: [email protected] > Subject: [UMN_MAPSERVER-USERS] WFS requests ignore PostGIS > columns beside the Geometry and ID column > > 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-besi > de-the-Geometry-and-ID-column-tp14766031p14766031.html > Sent from the Mapserver - User mailing list archive at Nabble.com. >
