MapServer with Postgis 0.8.2 on Win32

[Stefano Bonnin]

I have just installed Mapscript 4.3 at 

http://maptools.org/php_mapscript/index.phtml?page=downloads.html

and I have installed Postgres 8.0.0beta1 and Postgis 0.8.2 under a Win32 platform

When I try to run my application that works under linux platform I get a strange error:

**************************************
<b>Warning</b>:  [MapServer Error]: msDrawMap(): Failed to draw layer named 'lyr_40'.
 in <b>c:\programmi\apache group\apache\htdocs\crs\gisKernel.map</b> on line <b>441</b><br />
<br />
<b>Warning</b>:  [MapServer Error]: prep_DB(): Couldnt recover from a bad query: 
'DECLARE mycursor BINARY CURSOR FOR SELECT type::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (SELECT the_geom,gid,type,name,poi_id from edtlyr_40_1 WHERE site_id = 1) as foo WHERE the_geom && setSRID('BOX3D(1405925.84354588 5001310.327485,1406917.73083212 5002055.106963)'::BOX3D, -1 )'

 in <b>c:\programmi\apache group\apache\htdocs\crs\gisKernel.map</b> on line <b>441</b><br />
****************************************

1) I think that this depends from 2 different postgis version. What version of postgis is compiled with the last mapscript version?

2) I noticed that the last version of postgis has a different geometry_columns table. How can I migrate with a pg_dump to a 0.8.2 version?

Thanks in advance.

RedS
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20040901/74b36793/attachment.htm>