[postgis-users] itemnquery limitation

[Tom Melhuish]

Dave,

Attached is the httpd errors that I received when running more then 21 nodes
using your mappostgis.c file. If I run under 21 nodes, I still only get a
header drawn with no map or controls and no error messages in the httpd log.
I recompiled the code with the original mappostgis.c file and I can get it
to work with 21 nodes again, but not with your new mappostgis.c file.

I've attached the header, footer, and html files.

tom

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of David
Blasby
Sent: Monday, August 11, 2003 3:50 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] itemnquery limitation


Tom,

I've been unable to reproduce your problem.

1. I've been directly accessing the mapserv CGI instead of through a
http server, so this could be where you're having problems.  You didnt
sent me "WCms_header.html" - is there anything 'funny' in it?

2. I changed one of the lines in your html file:
	<input type="hidden" name="qstring" value='"nodeid in
(413.0,430.0,431.0,432.0,433.0,434.0,436.1,450.0,451.0,452.0,453.0,454.0,455
.0,456.0,457.1,457.2,457.3,457.4,458.1,458.2,459.0,528.0)"'>

3. I noticed a minor problem in the mappostgis.c - it wasnt finishing
off its transactions to the query-by-unique-column portion.  I dont
think this would be the cause of the problem.  I've attached a new
mappostgis.c that fixes this problem (and throws out some debugging).


Could you try installing the new mappostgis.c and running your query?
It should give some output (probably in your httpd's error_log) like this:

msPOSTGISLayerGetShape called for record = 3532689
msPOSTGISLayerGetShape sql=DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR') from nodescomb_2003
WHERE OID = 3532689

Hopefully this will work.

dave

ps. I think mapserver does its queryN by doing this:
1. turn the query string into a FILTER clause
2. execute the normal LayerWhichShapes(<rect>)- remember the record numbers
3. execute the 'GetShapebyID()' for each of the record numbers.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mappost.error
Type: application/octet-stream
Size: 15189 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030812/9a1ce919/attachment.obj>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030812/9a1ce919/attachment.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030812/9a1ce919/attachment-0001.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030812/9a1ce919/attachment-0002.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030812/9a1ce919/attachment-0003.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030812/9a1ce919/attachment-0004.html>