[postgis-users] Postgis error with mapserver

[joanvp]

 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 : 
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060117/015ba04c/attachment.html>