[Gfoss] mapfile - postgis

[Luca Delucchi]

Il giorno mer, 07/05/2008 alle 10.07 +0200, Davide ha scritto:
> Ri-ciao .... prova a fare una prova importando dal mio database PG
> perchè a me con pmapper funge scritto così.....
> 
> 

mi dice che la colonna the_geom nn esiste! :(

luca a debianluca:~$ shp2img -m mapserver/davide.map -o da.png
msDrawMap(): Image handling error. Failed to draw layer named 'strade'.
<br>
prepare_database(): Query error. Error executing POSTGIS DECLARE (the
actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
"highway"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid1::text from public.it_osm_line WHERE the_geom && setSRID('BOX3D(6 34.75,19 47.75)'::BOX3D, 4326 )' 

Postgresql reports the error as 'ERROR:  column "the_geom" does not
exist
'

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/ 

Mappostgis.c - version of Jan 23/2004.
 <br>


> Ciao
> D

ciao
Luca