[postgis-devel] dump(geometry)

[Markus Schaber]

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