[postgis-users] geometry_inter function crashes database / solaris / postgres 7.4
Paul Ramsey
pramsey at refractions.net
Tue Jan 13 16:46:25 PST 2004
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
\_
More information about the postgis-users
mailing list