Hi Gerben, not sure if this is the reason why but I noticed that under the layer block you set Data as ' DATA 'the_geom FROM pr2007' ', I think you need a "USING UNIQUE" clause in there to specify which column in the table can act as a unique identifier and maybe an srid clause as well to specify the projection of the postgis table.
For instance USING UNIQUE ogc_fid USING SRID =32633. (Where ogc_fid is the unique identifier in my postgis table and 32633 is the EPSG code of the table data) Try appending these clauses to the 'Data' line in your layer block and see what happens. G. Tiemens wrote: > > Hello List, > > I want to try to get certain features-attribute information back from my > postgis database via Mapserver. > > I tried this in 2 ways: > Enabeling WFS in the mapfile and making a query layer. > > Both requests generate errors on the Postgis Database and i can't discover > what is going wrong. > > > > Both queries are also done with shapefile data, and that works fine. I get > features back (wfs) or the template (nquery) is filled in correctly > > > Below the parts of my mapfile and templates. > > Mapfile: > LAYER NAME 'pr2007' TYPE POLYGON CONNECTIONTYPE postgis > CONNECTION 'host=127.0.0.1 user=***** dbname=*****' DATA 'the_geom > FROM pr2007' #DATA 'C:\Project\Downloads\OSM\Data\pr\pr2007' > PROCESSING "CLOSE_CONNECTION=DEFER" METADATA 'ows_title' > 'prov2007' "ows_abstract" "" "ows_keywordlist" "" > "gml_featureid" > "gid" ## REQUIRED "gml_include_items" "all" ## Optional (serves all > attributes for layer) "ows_srs" "EPSG:28992" # "queryable" > "true" > "wfs_geometry_element_name" "the_geom" "wfs_extent" "12500 380000 > 280000 550000" END #DUMP TRUE STATUS ON #DEFAULT #opacity > 100 PROJECTION "init=epsg:28992" END HEADER > "imapheader.html" > FOOTER "imapfooter.html" CLASS COLOR 0 0 0 TEMPLATE > "bodytemplate.html" END END > > > > > > -- View this message in context: http://www.nabble.com/Query-using-template-and-WFS-errorred-on-POSTGIS-tp20012197p20014232.html Sent from the Mapserver - User mailing list archive at Nabble.com. _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
