[mapserver-users] Is PostGIS broken in latest nightly build on Win32?

[Pericles S. Nacionales]

Sean,

The PostGIS client library that I compiled with MapServer is from version
7.1.3.  It may or may not have to do with your problem.  You might want to
think about upgrading to 7.1.3 although I can't guarantee that it'll work.

You might also want to compile the Postgresql 7.1.2 client library 
yourself and replace the libpq.dll that came with the MapServer
binary.  Again, I don't if it will work.

Good luck!

-Perry

On Mon, 11 Mar 2002, Sean Gillies wrote:

> Greetings,
> 
> Am having sucess using PostGIS (very recent CVS build) as a data source
> with mapserver built on Linux but am unable to use this same data source
> with the most recent ms351_nightly w/postgis.
> 
> I am seeing this error:
> 
> msPOSTGISLayerWhichShapes(): Query error. Error executing POSTGIS SQL 
> statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT 
> State_abbr::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),oid::text 
> from dtlst WHERE the_geom && setSRID('BOX3D(-126 22.2637931034483,-65 
> 51.7362068965517)'::BOX3D, find_srid('','dtlst','the_geom') )
> 
> The win32 binary works with shapefile data, but not with a PostGIS data 
> source which works with our Linux mapserver.  The PostgreSQL server
> is on Linux and we reliably access it from many other windows
> applications.
> 
> The software versions are:
> PostgreSQL 7.1.2
> PostGIS 0.7-ish (from CVS on March 5)
> Mapserver win32 binary w/ postgis from March 11
> 
> Looking forward to hearing any solutions or suggestions,
> 
> Sean
>