[postgis-users] Postgis error with mapserver

[Paul Ramsey]

Change your data statement in your mapfile to:

DATA "geom from inun_riscalt"

That may not work.
If you loaded the table with a mixed case, drop it and load it again  
with all lower case, I am not sure the Mapserver mappostgis.c can  
handle mixed case table names.  In fact, looking at the SQL it is  
generating, I am sure it cannot.

P.

On Jan 17, 2006, at 8:47 AM, joanvp wrote:

>  Hi!!
>
> I've tried to show a postgis layer with UMN Mapserver. I've  
> installed last version of postgresql with postgis (8.1). I've  
> imported a shapefile with FME.
>
> I've tried this layer with Quantum GIS and all works fine. The  
> problem is with UMN Mapserver (v4.6). This is the error log
>
> ----------------------------------------------
> Warning: [MapServer Error]: prepare_database(): Error executing  
> POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor  
> BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d 
> (geom)),'NDR'),OID::text from public.Inun_RiscAlt WHERE geom &&  
> setSRID('BOX3D(326607 4245586.875,627250 4471069.125)'::BOX3D,  
> find_srid('','public.Inun_RiscAlt','geom') )'
>
> Postgresql reports the error as 'ERROR: relation "inun_riscalt"  
> does not exist '
>
> More Help:
>
> Error with POSTGIS data variable. You specified '<check your .map  
> file>'.
> Standard ways of specifiying are : < br>(1) 'geometry_colum n 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.php
>
> ------------------------
> This is my mapfile
> (....)
> LAYER
>   NAME inun_riscalt
>   TYPE POLYGON
>   STATUS On
> CONNECTION "user=xxx password=xxxx dbname=bdmapserver  
> host=localhost port=5432"
> CONNECTIONTYPE postgis
> DATA "geom from Inun_RiscAlt"
>   CLASS
>     NAME "Inun_RiscAlt "
>     COLOR 182 131 78
>     OUTLINECOLOR 4 24 93
>   END
> END
> (...)
>
> Any solution?
>
> Thank you in advanced
>
> Yahoo! Photos
> Ring in the New Year with Photo Calendars. Add photos, events,  
> holidays, whatever.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users