[postgis-users] Query crashed

Stephen Woodbridge woodbri at swoodbridge.com
Sat Nov 19 13:56:23 PST 2005


Hi all,

I was running the following query:

select count(*)
from
   roadseg r, streets s
where
   buffer(r.the_geom, 0.00007) && s.the_geom and
   within(s.the_geom, buffer(r.the_geom, 0.00007));

And it crashed with the following error message after running for 
1,959,844 ms in pgadmin3:

NOTICE:  LWGEOM_gist_joinsel called with arguments that are not column 
references
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

The "roadseg" table is the geobase roadseg data for all provinces loaded 
into a table and the "streets" is the same for the Census streets data 
for all provinces.

postgis_full_version() reports:
POSTGIS="1.0.4"
GEOS="2.0.1"
PROJ="Rel. 4.4.9, 29 Oct 2004"
USE_STATS DBPROC="0.3.0"
RELPROC="0.3.0"

and version() reports:

"PostgreSQL 8.0.4 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC) 
3.4.2 [FreeBSD] 20040728"

Any ideas on what this is about. All the data was loaded via shp2pgsql.

Thanks,
   -Steve



More information about the postgis-users mailing list