[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