[postgis-users] Intersects(geometry,geometry) fails

[Greg Janée]

Using Intersects(geometry,geometry) fails and furthermore causes the 
database connection to get hosed:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
% psql spatialtest
Welcome to psql 7.4, the PostgreSQL interactive terminal.

spatialtest=# select * from main;
  id |                   footw
----+-------------------------------------------
   1 | SRID=54001;POLYGON((0 0,2 0,7 5,2 5,0 0))
(1 row)

spatialtest=# select * from main where
spatialtest-# Intersects(footw,
spatialtest(# GeometryFromText('POLYGON((2 0,5 0,5 3,2 3,2 0))',54001));
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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


I'm using PostGIS 0.8.0.  Info about the spatial column in question:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
spatialtest=# select * from geometry_columns;
  f_table_catalog | f_table_schema | f_table_name | f_geometry_column | 
coord_dimension | srid  |   type   | attrelid  | varattnum | stats
-----------------+----------------+--------------+-------------------+-----------------+-------+----------+-----------+-----------+-------
                  | spatialtest    | main         | 
footw             |               2 | 54001 | GEOMETRY | 125326745 
|         2 |
(1 row)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Thanks,
-Greg

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Greg Janée                              Department of Computer Science
gjanee at alexandria.ucsb.edu                    University of California
                                           Santa Barbara, CA 93106-5110
                                805-893-8453 (voice) 805-893-3045 (fax)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~