[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