postgis

[uli mueller]

Jachym

Try changing FROM to lowercase from.

Uli

-- 
geOps GeoInformatics
D-79100 Freiburg

Jachym Cepicky wrote:
> Hallo,
> I have following problem with mapserver: I can not load vector file
> stored in postgis.
> 
> I use Debain (testing), with mapserver from official repository and
> postgis from the Debian-Gis project
> (http://pkg-grass.alioth.debian.org/cgi-bin/wiki.pl). 
> 
> I stored vector shape file with help of shp2pgsql apparently without
> problems. I can acces the file e.g. usin Qgis and I can load it to
> GRASS GIS.
> 
> However mapserver gives me quite long report, about that he is not able
> to display the map. 
> 
> [...]
> msDrawMap(): Image handling error. Failed to draw layer named 'obrys'.
> prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT kod::text,popis::text,asbinary(force_collection(force_2d()),'NDR'),OID::text from WHERE && setSRID('BOX3D(-599514.328920447 -1159983.83918495,-581875.449556553 -1142344.95982105)'::BOX3D, find_srid('','','') )'
> 
> Postgresql reports the error as 'ERROR: syntax error at or near "WHERE" at character 126 '
> [...]
> (I posted the whole file to http://les-ejk.cz/tmp/mapserver.html)
> 
> The mapfile part for the layer follows:
> LAYER
>     NAME obrys
>     TYPE polygon
>     METADATA
>         "title" "LH SLP Krtiny"
>     END
>     CONNECTIONTYPE POSTGIS
>     CONNECTION "host=10.0.0.24 dbname=krtiny user=jachym"
>     DATA "the_geom FROM obrys"
>     CLASSITEM kod
>     LABELITEM popis
>     MINSCALE 50000
>     CLASS
>         EXPRESSION '1'
>         NAME 'PUPFL "SLP Krtiny"'
>         COLOR 49 135 32
>     END
>     CLASS
>         EXPRESSION '2'
>         NAME 'Sidlo'
>         COLOR 190 190 190
>         LABEL
>             TYPE truetype
>             FONT arialce
>             SIZE 7
>             COLOR 0 0 0
>             BACKGROUNDCOLOR 255 255 255
>         END
>     END
> END
> 
> In /etc/postgresql/pg_hba.conf is:
> host    krtiny  jachym       10.0.0.24       255.255.255.0  trust
> 
> 
> What to do?
> 
> Thank you
> 
> Jachym