[mapserver-users] Conexion with postgres-postgis

[Alexandre Dube]

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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>   


-- 
Alexandre Dubé
Mapgears
www.mapgears.com