[postgis-users] itemnquery limitation

[Tom Melhuish]

Dave,
Sorry, I was out on Friday. Attached is the PG_DUMP of my nodes table
(nodescomb_2003.sql) along with the sql statements (NodeTbl_2003.sql) that I
actually used to create the table. I'm using perl to create the html file
that calls mapserv, so I copied the source (test.html) along with the map
file (WCms.map) to help you recreate the problem at your location. Let me
know if you need anything else.

Thanks to Zamil Murji for helping out with this problem the last few days.

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: Friday, August 08, 2003 1:40 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] itemnquery limitation


Zamil Murji wrote:
> WHAT?? That can't be good. What do you think I did wrong. For a smaller
subset of the data (ie. a select that that worked) this is what I got:

No - thats not good.

> Exactly what I expected to get back...What have i done wrong? The query
seems to fail on larger record sets. What can I do to trace this error?

Its difficult to debug this.  But if you pg_dump your table and send it
to me I can run it here and fix the problem.

dave


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: nodescomb_2003.sql
Type: application/octet-stream
Size: 1874558 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030811/ae21e600/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: NodeTbl_2003.sql
Type: application/octet-stream
Size: 1084 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030811/ae21e600/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: WCms.map
Type: application/octet-stream
Size: 8596 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030811/ae21e600/attachment-0002.obj>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030811/ae21e600/attachment.html>