[postgis-users] PostGIS with Mapserver/Mapscript 4.0

[Mike Leahy]

David,

Thanks for the response, and I apologize for the confusion.  

Unfortunately, I think I'm going to have to sit tight and wait until a Win32
build is available.  I've already tried compiling/installing the supporting
packages required for Mapserver, and that alone is leading me to more
errors.  I don't think I could get this done in a reasonable amount of time.
On top of that, I'm running MapServer with IIS in WinXP...I'm not really
sure if Mapserver compiled in cygwin work for IIS - would it?  Is there any
way for me to know when the changes have been updated in Win32 development
version of Mapserver?

The project I'm working on is developing a spatially-enabled education
quality assessment database for use by participants from developing
countries.  Our goal is to get something presentable running before
November.  While things are working more-or-less with the older 'unknown'
build of PostGIS that we have, I was hoping to take advantage of more useful
functionality in the latest versions.

At any rate, I really appreciate your help.

Kind regards,
Mike

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of David
Blasby
Sent: September 16, 2003 12:37 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS with Mapserver/Mapscript 4.0

Mike Leahy wrote:
> As a workaround, I changed the USE_GEOS parameter to 0 in the
makefile...so
> I was able to install PostGIS without the GEOS support.  Unfortunately,
I've
> come full-circle to my original problem.  I'm still getting the warning
> messages tacked onto the end of my PHP script output when performing a map
> query that selects more than one object:
> 
> 
>>WARNING: BEGIN: already a transaction in progress WARNING: Closing 
>>pre- existing portal "mycursor" WARNING: BEGIN: already a transaction 
>>in progress
>>WARNING: Closing pre-existing portal "mycursor" WARNING: BEGIN: already a 
>>transaction in progress WARNING: Closing pre-existing portal "mycursor" 
>>WARNING: etc...

Two things, mike;

1. You need to re-compile mapserver, not PostGIS
2. As I said in my last message, I havent actually committed the changes 
yet.  (I made a bunch of other very minor changes and havent had time to 
test them)

I've attached a mappostgis.c that you can use in mapserver that should 
solve your problem.

dave