AW: [postgis-users] Postgis8 and WMS getfeatureinfo

Christina Biakowski christina.biakowski at ccgis.de
Wed Jan 7 05:03:11 PST 2004


The MAP-file is attached. The queryable Layer is "Staedtepunkte".

Christina

-----Ursprüngliche Nachricht-----
Von: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]Im Auftrag von
TECHER Jean David
Gesendet: Mittwoch, 7. Januar 2004 13:38
An: PostGIS Users Discussion
Betreff: RE: [postgis-users] Postgis8 and WMS getfeatureinfo


can you give us the file .map you use ?

TECHER Jean David
Tél: 06-85-37-36-75
e-mail: davidtecher at yahoo.fr

-----Message d'origine-----
De : postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]De la part de
Christina Biakowski
Envoyé : mercredi 7 janvier 2004 13:34
À : Mapserver-Users at Lists. Gis. Umn. Edu;
postgis-users at postgis.refractions.net
Objet : [postgis-users] Postgis8 and WMS getfeatureinfo


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


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
A non-text attachment was scrubbed...
Name: germany_postgis1.map
Type: application/octet-stream
Size: 7418 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040107/b4769ebd/attachment.obj>


More information about the postgis-users mailing list