[postgis-users] itemnquery limitation

[Zamil Murji]

Sorry I jumped the gun. I had well_noded in the first query instead of well_node. SO, my fault! 

This means that postgres runs the query fine. It is in the processing of that data something goes wrong. In IE, it always spits out everything but the last entry and just sits (the globe is spinning). In java, eventually I will get an premature EOF exception.

Hope this helps you guys solve the problem.
Zamil

-----Original Message-----
From: Zamil Murji 
Sent: Friday, August 08, 2003 11:20 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] itemnquery limitation


Thanks David

I wanted to see if postgres db would return the full record set. So i ran the SELECT statement in my db without the DECLARE MY CURSOR stuff (hope that is what I have to do) and received the following error:
idc=# SELECT well_no::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from well_node WHERE (riley_logs = 'Y' OR riley_logs_rasters = 'Y' OR depth_registered = 'Y') and (the_geom && setSRID( 'BOX3D(-98.8288026335878 28.0235350561798,-98.7823497709924 28.0559511610487)'::BOX3D,find_srid('','well_noded','the_geom') ));
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#

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:

idc=# SELECT well_no::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from well_node WHERE (riley_logs = 'Y' OR riley_logs_rasters = 'Y' OR depth_registered = 'Y') and (the_geom && setSRID( 'BOX3D(-98.7920356870229 28.0494284082397,-98.7870938931298 28.0543698876404)'::BOX3D,find_srid('','well_node','the_geom') ));
  well_no  |                           asbinary                           |   oid
-----------+--------------------------------------------------------------+----------
 180092638 | 0107000000010000000101000000068195438BB258C00551F701480D3C40 | 18749577
(1 row)

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?

Zamil

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


Zamil Murji wrote:
> How can I display the select statement in my browser?

Usually I just put an error in my DATA statement - this will cause it to 
kick out an error message that includes the select statement.

When I next do changes to mappostgis.c (4.0 version), I'll allow for the 
new DEBUG option.  I dont know where the output goes (http server's 
error_log or to the brower...).

dave


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

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