[postgis-users] itemnquery limitation

[Zamil Murji]

I did some digging arount in the mapserver code. Pretty clean I must say, good job!
I added the following line of code to the end of msPOSTGISLayerWhichShapes in mappostgis.c

number_of_tuples = PQntuples(layerinfo->query_result);
fprintf(stderr,"ZAMIL: Number of tuples returned = %i\n", number_of_tuples);

I always get a number greater than 41 in the log file. So the error must be in the processing of the records. It just hangs after printing the 41 record. Also I get a whole bunch of this in my log file? 
[Tue Aug 12 10:23:21 2003] [error] [client 10.0.50.205] WARNING:  BEGIN: already a transaction in progress
[Tue Aug 12 10:23:21 2003] [error] [client 10.0.50.205] WARNING:  Closing pre-existing portal "mycursor"
[Tue Aug 12 10:23:21 2003] [error] [client 10.0.50.205] WARNING:  BEGIN: already a transaction in progress
[Tue Aug 12 10:23:21 2003] [error] [client 10.0.50.205] WARNING:  Closing pre-existing portal "mycursor"
[Tue Aug 12 10:23:21 2003] [error] [client 10.0.50.205] WARNING:  BEGIN: already a transaction in progress
[Tue Aug 12 10:35:04 2003] [error] [client 10.0.50.205] ZAMIL: Number of tuples returned = 45

-----Original Message-----
From: David Blasby [mailto:dblasby at refractions.net]
Sent: Tuesday, August 12, 2003 11:07 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] itemnquery limitation


Running it I get:

<h2>School Location with associated Nodes displayed</h2><br>
<!--
...
<b>QUERY METRICS</b>: number of layers with results=1, total number of 
results=22<br><br>
-->


or (with "nodeid >0" instead of the "nodeid in ..." stuff):


<!--
...
<b>QUERY METRICS</b>: number of layers with results=1, total number of 
results=746<br><br>
-->

Also, I cannot see how the new mappostgis.c version could be hurting you 
- i just added a wee bit to close off hanging transactions (they were 
being automatically closed by postgresql anyways).

I also ran it through valgrind - it doesnt look like anything nasty is 
happening.

I'll see if I can get it running through apache since thats the only 
place it could really be going wrong.

dave
ps. I dont have the WCms_nodes_header.html,WCms_nodes_footer.html, or 
WCms_nodes.html file.


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users