<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body bgcolor="#ffffff" text="#000000">
<pre>Dear all,
I am quite new to mapserver and maybe I am just missing some important configuration step but I hope somebody
of you can help me with following problem:
When trying to perform a query via a cartoweb-client to a layer stored in Postgis I encounter following error message
(It is only the query that is not working the layer itself renders perfect out of the database):
MapServer error: Error in msDrawMap(): Failed to draw layer named 'bound'.
Error in msPostGISLayerResultsGetShape(): Got request larger than result set.
When I do the same with the layer as shapefile on the file system the query functions as expected.
<b>My system environment is:</b>
cartoweb 3.5.0
php 5.3.3
Mapserver version 5.6.5
Postgis 1.5.1
Postgresql 8.4.4
Operating System: Suse Linux 11.3
<b>In the mapfile the layer is defined as follows</b>
LAYER
NAME "bound"
TYPE LINE
STATUS ON
CONNECTIONTYPE POSTGIS
CONNECTION "user=*** password=*** host=localhost dbname=gis"
DATA "the_geom FROM (select * from dep_france_dom) as foo using unique gid using srid=-1"
TEMPLATE "ttt"
METADATA
"id_attribute_string" "id_geofla"
"query_returned_attributes" "id_geofla"
END
CLASS
NAME "Boundaries"
STYLE
COLOR 200 200 200
OUTLINECOLOR 255 165 96
END
END
END
</pre>
</body>
</html>