<b>Hi!!<br><br>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.<br><br>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<br><br>----------------------------------------------<br>Warning</b>: [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') )' <br><br>Postgresql reports the error as 'ERROR: relation "inun_riscalt" does not exist '<br><br>More Help:<br><br>Error with POSTGIS data variable. You specified '<check your .map file>'.<br>Standard ways of specifiying are : <br>(1) 'geometry_column from
geometry_table' <br>(2) 'geometry_column from (<sub query>) as foo using unique <column name> using SRID=<srid#>' <br><br>Make sure you put in the 'using unique <column name>' and 'using SRID=#' clauses in. <br><br>For more help, please see http://postgis.refractions.net/documentation.php <br><br>------------------------<br>This is my mapfile<br>(....)<br>LAYER<br> NAME inun_riscalt<br> TYPE POLYGON<br> STATUS On<br>CONNECTION "user=xxx password=xxxx dbname=bdmapserver host=localhost port=5432"<br>CONNECTIONTYPE postgis<br>DATA "geom from Inun_RiscAlt"<br> CLASS<br> NAME "Inun_RiscAlt "<br> COLOR 182 131 78<br> OUTLINECOLOR 4 24 93<br> END<br>END<br>(...)<br><br>Any solution?<br><br>Thank you in advanced<br><p>
<hr size=1>Yahoo! Photos<br>
Got holiday prints? <a href="http://us.rd.yahoo.com/mail_us/taglines/holidayprints/*http://pa.yahoo.com/*http://us.rd.yahoo.com/mail_us/taglines/photos/evt=38089/*http://pg.photos.yahoo.com/ph//print_splash">See all the ways</a> to get quality prints in your hands ASAP.