[postgis-users] Postgres segfaults on some geometry functions

[David TECHER]

did you try

geometryfromtext('POLYGON((0.5 0.5,0.5 1.5,1.5 1.5,1.5
> 0.5,0.5 0.5))',yoursrid)???

 --- Havard Tveite <havard.tveite at nlh.no> a écrit : >
I am on Solaris 2.7, GCC 3.3.2, Postgres 7.4.1, GEOS
> 1.0.0, Postgis
> 0.8.1 (I had to compile postgis with -fPIC in the
> CXXFLAGS to be able to
> build shared libraries).
> 
> I seem to be having problems with geometry functions
> that return
> geometry. All geometric predicates seem to run fine,
> and so does
> other "geometry"-functions such as isempty and
> geometrytype.
> 
> I have tested:
> select buffer('POLYGON((0.5 0.5,0.5 1.5,1.5 1.5,1.5
> 0.5,0.5 0.5))',5);
> select geomunion( 'POLYGON((0.5 0.5,0.5 1.5,1.5
> 1.5,1.5 0.5,0.5 0.5))', 'POLYGON((0 0,0 1,1 1,1 0,0
> 0))');
> select intersection('POLYGON((0.5 0.5,0.5 1.5,1.5
> 1.5,1.5 0.5,0.5 0.5))', 'POLYGON((0 0,0 1,1 1,1 0,0
> 0))');
> and all fail with the following response:
> "
> 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.
> "
> Postgresql recovers from the failure.
> 
> The postgresql log does not show much, even with
> debug5 set. This is
> the result with "notice":
> 2004-05-11 17:35:25 LOG:  statement: select
> buffer('POLYGON((0.5 0.5,0.5 1.5,1.5
>   1.5,1.5 0.5,0.5 0.5))',5);
> 2004-05-11 17:35:31 LOG:  server process (PID 9006)
> was terminated by signal 11
> 2004-05-11 17:35:31 LOG:  terminating any other
> active server processes
> 2004-05-11 17:35:31 LOG:  all server processes
> terminated; reinitializing
> 2004-05-11 17:35:31 LOG:  connection received:
> host=[local] port=
> 2004-05-11 17:35:31 FATAL:  the database system is
> starting up
> 
> What could be the problem?
> 
> -- 
> Håvard Tveite
> Department of Mathematical Sciences and Technology
> Agricultural University of Norway
> Drøbakveien 14, POBox 5003, N-1432 Ås, NORWAY
> Phone: +47 64948857 Fax: +47 64948810
> http://www.nlh.no/imt
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users 


	

	
		
Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit partout ! 
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

Dialoguez en direct avec vos amis grâce à Yahoo! Messenger !Téléchargez Yahoo! Messenger sur http://fr.messenger.yahoo.com