[postgis-users] Postgis8 and WMS getfeatureinfo

Christina Biakowski christina.biakowski at ccgis.de
Wed Jan 7 04:33:53 PST 2004


Dear list,

we have setup a new system (FreeBSD 4.9) with Postgis 8/PostgreSQL 7.4 on
which we are running into an error. At the moment we are having a Postgis
7.5/PostgreSQL 7.3.4 box running well on FreeBSD 4.7.

While querying of shapefiles works fine, with Postgis-Layers we run into an
error with the getfeatureinfo-request - but only with multiresults. When the
getfeatureinfo-request returns only one resultset everything is fine, with
multiresults only one resultset is shown and we get the following error
message:

"Content-type: text/html msPOSTGISLayerGetShape(): Query error. Error
executing POSTGIS SQL statement (in FETCH ALL): DECLARE mycursor BINARY
CURSOR FOR SELECT
gid::text,objectid::text,area::text,perimeter::text,pppoint_::text,pppoint_i
d::text,pppttype::text,ppptname::text,ppptflag::text,polygonid::text,scale::
text,angle::text,name_neu1::text,name_typ::text,asbinary(force_collection(fo
rce_2d(the_geom)),'NDR') from staedte WHERE OID = 184315 -ERROR: cursor
"mycursor" already exists
More Help:
Error with POSTGIS data variable. You specified ''.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (<sub query>) as foo using unique <column name>
using SRID=<srid#>'

Make sure you put in the 'using unique <column name>' and 'using SRID=#'
clauses in.

For more help, please see http://postgis.refractions.net/documentation.php

Mappostgis.c - version of April 14/2003."

Are there any known incompatibilities between MapServer and PostGIS 8? Thank
you in advance for any hint,

best regards

Christina




More information about the postgis-users mailing list