postgis

[Jachym Cepicky]

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
-- 
Jachym Cepicky
e-mail: jachym.cepicky at centrum.cz
URL: http://les-ejk.cz
GPG: http://les-ejk.cz/gnupg_public_key/