[postgis-users] please NEED help....

Sébastien DUBOIS sebastien.dubois at esm2.imt-mrs.fr
Mon Jul 19 01:04:29 PDT 2004


>Use the CVS version of mapserver.
>What's the date on your version just after the error message?

Mappostgis.c - version of June 12/2003
do you think my version is too old?
can i download only a new version of mappostgis without changing the version of
mapserver, postgresql?
thanks for your help

> 
> With this code, i succeed in displaying my point (with label POINT(X,Y))
> 
> BUT
> 
> *when i make a query on ONLY ONE POINT I can't display the attributes of my
> original shapefile (so the colums of clientspostgis)
> My metadata is correct ...
> No error when i query only no display
> 
> *when i make a query on MULTI points: ERROR
> -------------------------------
> Warning: [MapServer Error]: msPOSTGISLayerGetShape(): Error executing POSTGIS
> SQL statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT
> the_geom::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from
> clientspostgis WHERE oid = 19621 -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. 
> ----------------------
> 
> 
> 
> 
> I've read that sometimes in old version the multipoint query error is due to
> postgis not closed at the end of a requet but i have the last version of
> mapserv and postgis ...
> 
> CAN SOMEONE GIVE ME SOME HELP??
> 
> 
> -- 
> Sébastien DUBOIS
> Ecole Généraliste d'Ingénieurs de Marseille (ex ESM2)
> 
> 1024D/A1140BCB 
> Empreinte de la clé = 1BC8 7E21 4DA7 13D5 1B5F  876F F719 2B7A A114 0BCB
> disponible sur www.keyserver.net


-- 
Sébastien DUBOIS
Ecole Généraliste d'Ingénieurs de Marseille (ex ESM2)
Portable: 0622751265

1024D/A1140BCB 
Empreinte de la clé = 1BC8 7E21 4DA7 13D5 1B5F  876F F719 2B7A A114 0BCB
disponible sur www.keyserver.net





-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/



More information about the postgis-users mailing list