postgis

[Jachym Cepicky]

hallo,
that was it. Hmm.. I read the documentation (MapServer Reference Guide
for Vector Data Access), where this but was described.. but it did not
    help.. Now it works. 

Any way, thank you for making me try it again.

jachym

On Thu, Jul 21, 2005 at 11:18:00AM +0200, uli mueller wrote:
> 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
> 
> 

-- 
Jachym Cepicky
e-mail: jachym.cepicky at centrum.cz
URL: http://les-ejk.cz
GPG: http://les-ejk.cz/gnupg_public_key/