[postgis-users] Postgis error with mapserver

[Miguel de la Fuente]

Try to put this in DATA
DATA "the_geom FROM (select OID,* from Inun_RiscAlt) as foo using unique OID
using srid=your srid"


On 1/17/06, joanvp <joanvp at yahoo.com> 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<http://us.rd.yahoo.com/mail_us/taglines/photos/*http://pa.yahoo.com/*http://us.rd.yahoo.com/mail_us/taglines/photos/evt=38087/*http://pg.photos.yahoo.com/ph//page?.file=calendar_splash.html&.dir=>.
> Add photos, events, holidays, whatever.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060117/2f5ceb80/attachment.html>