PostGIS with Mapserver/Mapscript 4.0

Hello All,

Here's my current problem, for those that haven't seen my post in other groups:

I've just now been able to get maps working in MapLab, using PostGIS layers
(PostGIS 0.7.5 in PostgreSQL 7.3.4-2, built in cygwin on WinXP). The maps
display fine, and if I do a point query, that also works fine. However, there
are two problems that occur when I query multiple objects (i.e., with a box
query instead of a point). First, and more important, is that the ROSA applet
doesn't display the image. If I go directly to the IMG_URL parameter for the
Rosa applet, the image is there, and looks fine, but the actual applet just
gives me a white box, with the navigation controls visible.

Second, I get a series of warning messages in the query attributesn (tacked on
to the end of the HTML text right after the last </html> tag), such as the
following:

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...

I finally figured out that these are the messages that are being returned by
PostgreSQL - with the older versions of Mapscript and PostGIS, the messages
were just sent to the command window that was running postmaster. The same
thing happens with the newer Mapscript (4.0) and the older version of
PostgreSQL/PostGIS (unknown).

So here's my question to the PostgreSQL/PostGIS experts - is there any way I
can prevent PostgreSQL/PostGIS from writing its warning messages to the output
from the PHP script? I have no idea where the logs from the postmaster
service are being saved - I'd prefer if I could get the warnings sent there
only, and not to the mapscript DLL.

Many thanks,
Mike

----------------------------------------
This mail sent through www.mywaterloo.ca