[postgis-users] geometry_inter function crashes database / solaris / postgres 7.4

[Paul Ramsey]

You should not be using that function.
It is a shame it crashes the server though.
It is for native r-tree support, which is deprecated in any event. (We 
use GiST r-trees now.)

 From your query, it looks like you actually want the 'Intersection()' 
function (GEOS support required).

Gregory S. Williamson wrote:

> We've got a select which returns five rows (out of a few hundred thousand) when done without the geometry_inter function. When we call this function we get a fatal crash that brings down postgres.
> 
> select an_id, the_geom,
>  area(geometry_inter(the_geom, GeometryFromText('POLYGON((-76.7714616961 38.7472033948, -76.7663097341 38.7472033948, -76.7663097341 38.7444988547, -76.7714616961 38.7444988547, -76.7714616961 38.7472033948))', 4326))) from our_shapes where the_geom && GeometryFromText('POLYGON((-76.7714616961 38.7472033948, -76.7663097341 38.7472033948, -76.7663097341 38.7444988547, -76.7714616961 38.7444988547, -76.7714616961 38.7472033948))', 4326);
> 
> 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: Succeeded.
> 
> 
> =========
> 
> It usually dies and I have to exit the psql program. Postgres itself comes back up ok:
> 
> DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
> HINT:  In a moment you should be able to reconnect to the database and repeat your command.
> WARNING:  terminating connection because of crash of another server process
> DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
> HINT:  In a moment you should be able to reconnect to the database and repeat your command.
> ...
> 2004-01-13 16:31:08 LOG:  database system is ready
> 
> ==========
> A few details
> uname -a
> SunOS servername 5.9 Generic_112234-05 i86pc i386 i86pc
> 
> psql --version
> psql (PostgreSQL) 7.4
> 
> And:
> select postgis_version();
>             postgis_version
> ---------------------------------------
>  0.8 USE_GEOS=0 USE_PROJ=1 USE_STATS=1
> (1 row)
> 
> ============
> 
> This seems similar to another thread about intersection failing in much the same way.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_