Valeria: I think the problem is that your data statment is incomplete. You should write something like: DATA: "the_geom from chile_comuna as foo using unique <unique column name> using srid=<yourSRID>" Hope it helps,
Saludos Luis 2009/1/12 Valeria Muñoz <[email protected]> > 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 > >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
