[postgis-users] PostGIS with Mapserver/Mapscript 4.0

[Mike Leahy]

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