[mapserver-users] Conexion with postgres-postgis

[Valeria Muñoz]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090112/10efb7da/attachment.htm>