Postgis 0.8.2 doesn't work on Win32

[Mladen Kotarac]

Stefano Bonnin wrote:

> Hi,
> I'have just installed Postgres 8.0.0beta1 and postgis 0.8.2 with the
> postgis installer found at
> http://dcmms.sourceforge.net/postgis_installer.php
> After some test (failed) with mapserver, I tryed to execute very
> simple query like:
> CREATE TABLE gtest ( ID int4, NAME varchar(20) );
> SELECT AddGeometryColumn('dbname','gtest','geom',-1,'LINESTRING',2);
> INSERT INTO gtest (ID, NAME, GEOM) VALUES (1, 'First Geometry',
> GeometryFromText('LINESTRING(2 3,4 5,6 5,7 8)', -1));
> SELECT id, name, AsText(geom) AS geom FROM gtest;
> id | name | geom
> ----+----------------+-----------------------------
> 1 | First Geometry | LINESTRING(2 3,4 5,6 5,7 8)
> SELECT id,name FROM GTEST WHERE GEOM && 'BOX3D(3 4,4 5)'::box3d;
> this query crashes the postgres.exe process on "windows XP home SP1"
> Can this depend on the OS?
> thanks,
> RedS

Dear Stefano,

obviosly it does, my WinMapserver/Mapscript 4.2.3 (the same with 4.2.2)
from maptools.org is not crashing PostgreSQL anymore and the error line
is slightly nicer ;-):

*Warning*: [MapServer Error]: prep_DB(): Couldnt recover from a bad
query: 'DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from not1
WHERE the_geom && setSRID('BOX3D(365000 8906.25,635000
211093.75)'::BOX3D, find_srid('','not1','the_geom') )' in ...

The problem probably lies in the libpq.dll (version 1.2.2003)
used/contained in the zip file) by this Mapserver.
Looks to be too rather old.

Which version of Mapserver are you using?

BR

Mladen

--
******************************************************************
Mladen Kotarac, univ.dipl.biol.
Center za kartografijo favne in flore
Centre for Cartography of Fauna and Flora
http://www.ckff.si

Antoliciceva 1, SI-2204 Miklavž na Dravskem polju, Slovenija
tel: 00386-(0)2-6295150
fax: 00386-(0)2-6295151

podružnica Ljubljana, Zemljemerska 10, SI-1000 Ljubljana, Slovenija
tel: 00386-(0)1-4382440
fax: 00386-(0)1-4382445

GSM: 00386-(0)41-735429
e-mail: mladen.kotarac at ckff.si