[UMN_MAPSERVER-USERS] MAPSERVER with Postgis. SELECT Queries with WFS returns only the header

[Maarten Plieger]

Hello all,

I am setting up UMN mapserver with postgis. At the moment i have a test 
database running with an esri world file imported to it. With WMS i can 
view this file with both DATA settings listed below. With WFS however, 
the second query does not return any data. I really would like to make 
queries on the postgis dataset, because the final dataset will be very 
large. And this data has to be available through WFS too. Am I 
misunderstanding something? Is it possible to make postgis queries on WFS?
I am running mapserver 5 beta 3.
"describefeaturetype" and "getcapabilities" returns exactly the same for 
both settings

(1)
DATA "the_geom from name"
# WMS=OK, WFS=OK

(2)
DATA "the_geom from (select gid,name,gmi_cntry,REGION,the_geom from 
name) as foo using unique the_geom using SRID=4326"
#WMS=OK, WFS=returns only header!

Part of my mapfile:
LAYER
 NAME test3
 TYPE LINE
 CONNECTIONTYPE postgis
 CONNECTION "bla bla"
 DATA "the_geom from (select gid,name,gmi_cntry,REGION,the_geom from 
name) as foo using unique the_geom using SRID=4326"
 #DATA "the_geom from name"
 METADATA
   "wfs_title"    "World_lines" ## REQUIRED
   "wfs_srs" "EPSG:4326"
   "wfs_extent" "-180 -90 180 90"
   "gml_featureid" "NAME" ## REQUIRED
   "gml_include_items" "all"  ## Optional (serves all attributes for layer)
 END
 DUMP TRUE

 PROJECTION
   "init=epsg:4326"
 END

 CLASS
   COLOR 0 0 0
 END
END


Thanks in advance,
Maarten Plieger