[postgis-devel] dump(geometry)

strk at refractions.net strk at refractions.net
Tue Jan 11 00:07:30 PST 2005


It was faulting on 7.4.3 as well.
Should be fixed now, please try again.
Note that I've been testing it on 7.2 and 7.3 as well...
but bugs don't like to show up ;)

--strk;

On Mon, Jan 10, 2005 at 04:04:13PM +0100, Markus Schaber wrote:
> Hi, Strk,
> 
> On Fri, 7 Jan 2005 01:50:21 +0100
> strk at refractions.net wrote:
> 
> > Also, this is only tested against postgresql 8.0.0.
> > Tests on previous postgresql versions are *very* welcome.
> 
> Here's my test with postgresql 7.4.6, using the geometry from your example:
> 
> lwgeom=# select version();
>                                                 version                                                
> -------------------------------------------------------------------------------------------------------
>  PostgreSQL 7.4.6 on i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.4 (Debian 1:3.3.4-13)
> (1 row)
> 
> lwgeom=# select isvalid('GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2)),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2))),LINESTRING(0 0,2 2,10 10,10 50))'::geometry);
>  isvalid 
> ---------
>  t
> (1 row)
> 
> lwgeom=# select * from dump('GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2)),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2))),LINESTRING(0 0,2 2,10 10,10 50))'::geometry);
> 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.
> 
> The syslog tells:
> 
> Jan 10 16:00:58 kingfisher postgres[20496]: [13-1] LOG:  statement: select version();
> Jan 10 16:01:02 kingfisher postgres[20496]: [14-1] LOG:  statement: select isvalid('GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2
> Jan 10 16:01:02 kingfisher postgres[20496]: [14-2]  2),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2)),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0
> Jan 10 16:01:02 kingfisher postgres[20496]: [14-3]  -3,1 10),POINT(2 2),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2))),LINESTRING(0 0,2 2,10 10,10
> Jan 10 16:01:02 kingfisher postgres[20496]: [14-4]  50))'::geometry);
> Jan 10 16:01:05 kingfisher postgres[20496]: [15-1] LOG:  statement: select * from dump('GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2
> Jan 10 16:01:05 kingfisher postgres[20496]: [15-2]  2),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2)),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0
> Jan 10 16:01:05 kingfisher postgres[20496]: [15-3]  -3,1 10),POINT(2 2),GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(0 -3,1 10),POINT(2 2))),LINESTRING(0 0,2 2,10 10,10
> Jan 10 16:01:05 kingfisher postgres[20496]: [15-4]  50))'::geometry);
> Jan 10 16:01:05 kingfisher postgres[1868]: [10-1] LOG:  server process (PID 20496) was terminated by signal 11
> Jan 10 16:01:05 kingfisher postgres[1868]: [11-1] LOG:  terminating any other active server processes
> Jan 10 16:01:05 kingfisher postgres[1868]: [12-1] LOG:  all server processes terminated; reinitializing
> 
> The question is whether I busted it up when compiling the CVS version
> from postgis, or it is a "real" bug.
> 
> Markus
> -- 
> markus schaber | dipl. informatiker
> logi-track ag | rennweg 14-16 | ch 8001 z├╝rich
> phone +41-43-888 62 52 | fax +41-43-888 62 53
> mailto:schabios at logi-track.com | www.logi-track.com
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel

-- 

For standing up against patentability of software,

  Thank You, Poland!

Read the intervention:    http://kwiki.ffii.org/ConsPolon041221En
Send your thanks:         thankyoupoland.info
Read/do more:		  http://www.noepatents.org/



More information about the postgis-devel mailing list