[postgis-users] itemnquery limitation

[Zamil Murji]

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