[postgis-users] Postgis error with mapserver

[strk at refractions.net]

You might try 
DATA 'geom from "Inun_RiscAlt"'
to see if mappostgis.c handles that.
--strk;

On Tue, Jan 17, 2006 at 08:56:19AM -0800, Paul Ramsey wrote:
> 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
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for low technology.
  X     Keep e-mail messages readable by any computer system.
 / \    Keep it ASCII.