Hi Valeria,
What was the options you used with your shp2pgsql script execution ?
Did you specify a -s property ?
Alexandre
Valeria Muñoz wrote:
HI
I am trying to connect postgres with my Mapfile, but I get the
following error:
msDrawMap(): Image handling error. Failed to draw layer named
'chile_comuna'. prepare_database(): Query error. Error executing
POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor BINARY
CURSOR FOR SELECT
"NAME"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
from chile_comuna WHERE the_geom && setSRID('BOX3D(-71.2556639435156
-29.9271886101172,-71.2540857172265 -29.9256103838281)'::BOX3D,
find_srid('','chile_comuna','the_geom') )' Postgresql reports the
error as 'ERROR: column "NAME" does not exist LINE 1: DECLARE mycursor
BINARY CURSOR FOR SELECT "NAME"::text,asbin... ^ ' 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.
I use the command shp2pgsql to pass the information of the shapefile
to postgres table.
MapFile
LAYER
NAME 'chile_comuna'
TYPE POLYGON
#DATA 'chile_comuna.shp'
CONNECTIONTYPE postgis
CONNECTION "user=postgres password=1234 dbname=geo_referencia
host=localhost"
DATA "the_geom from chile_comuna"
.....
can anyone help me? pleasee...
rgs
------------------------------------------------------------------------
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Alexandre Dubé
Mapgears
www.mapgears.com
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
