Postgis error with mapserver

[Don Isgitt]

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 :
> (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 
> <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> 
> to get quality prints in your hands ASAP. 

Joanvp,

Notice the  public.Inun_RiscAlt versus  inun_riscalt. Postgres forces 
names to lowercase unless they are enclosed in quotes.

Don