[Mapserver-users] Query error executing postgis declare

Sébastien DUBOIS sebastien.dubois at esm2.imt-mrs.fr
Wed Jun 9 00:50:57 PDT 2004


Hi, i've see an old post of you with the same query as mine
let's see my error output

----------------------------
msDrawMap(): Image handling error. Failed to draw layer named 'clients'.
prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual query)
statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(geom)),'NDR'),OID::text from clients WHERE
geom && setSRID('BOX3D(777239.130434783 1944100,803360.869565217
1964100)'::BOX3D, find_srid('','clients','geom') )'

Postgresql reports the error ''

More Help:

Error with POSTGIS data variable. You specified '<check your .map file>'.
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 June 12/2003. 
-----------------------


[postgre at s-gimli lib]$ postgres -V
postgres (PostgreSQL) 7.4

[postgre at s-gimli lib]$ /var/www/cgi-bin/mapserv_40.bin -v
MapServer version 4.0 OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF
SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT INPUT=JPEG INPUT=POSTGIS INPUT=OGR
INPUT=GDAL INPUT=SHAPEFILE



Have you used successfully the mappostgis.c gived by David Blasby?
http://postgis.refractions.net/pipermail/postgis-users/2004-January/003812.html


Or have youy solved your problem by another way?

thanks in advance



-- 
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





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




More information about the MapServer-users mailing list