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_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.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
 Got holiday prints? See all the ways to get quality prints in your hands ASAP.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060117/65d9caa4/attachment.htm>