[mapserver-users] MapServer - Win - PostGIS binary fails

Kjell-Olav Bjerknes kob at norkart.no
Tue Nov 5 02:25:19 EST 2002


Hi.

I'm using CygWin, Postgresql 7.2.3-1 and PostGIS 0.7.3 to store my 
geo_data.

I wanted MapServer to show my maps on the web. I downloaded the precompiled 
binaries for Windows (ms36gif_gdal_pg_wms.zip) from the MapServer site.

When I add a PostGIS layer in my map file I get an error: (f.ex. only shape 
layers works fine)

msPOSTGISLayerWhichShapes(): Query error. prep_DB:Error executing POSTGIS 
DECLARE statement (0.6 failed - retried 0.5 and it failed too). DECLARE 
mycursor BINARY CURSOR FOR SELECT 
name::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text 
from adresser WHERE the_geom && setSRID('BOX3D(-2600 2860.25,17900 
23343.75)'::BOX3D, find_srid('','adresser','the_geom') )

Does this have something to do with the versions I use (PostgreSQL 
7.2.3-1/PostGIS 0.7.3) and the versions the binaries support (PostgreSQL 
7.2.1/PostGIS 0.7.1)?
If so, dows anyone have win32 precompiled binaries supporting these 
versions?

Kjell-Olav




More information about the mapserver-users mailing list