[postgis-users] Problem with multipolygon

[Mark Cave-Ayland]

On Mon, 2007-11-19 at 16:07 +0100, Sebastian Bšöck wrote:
> Hi all,
> 
> i have a problem with multipolygon data. Taking the example data from
> the documentation:
> 
> test=# select GeomFromText('MULTIPOLYGON(((0 0,4 0,4 4,0 4,0 0),(1 1,2
> 1,2 2,1 2,1 1)), ((-1 -1,-1 -2,-2 -2,-2 -1,-1 -1)))');
>       geomfromtext
> --------------------
>    010600000000000000
> (1 row)
> 
> Sometimes it just works like above, but most of the time I get an 
> unexpected connection reset.
> 
> test=# select version();
>                          version
> 
> ---------------------------------------------------------------------
>    PostgreSQL 8.3beta2 on i386-apple-darwin9.1.0, compiled by GCC
> i686-apple-darwin9-gcc-4.0.1 (GCC) 4.0.1 (Apple Inc. build 5465)
> 
> As far I can tell, everything has worked for me until i switched to Mac
> OS X 10.5. I installed all software through macports.
> 
> How can I investigate this issue further?
> 
> Any help appreciated.
> 
> Thanks
> 
> Sebastian


Hi Sebastian,

The best option would be to compile PostgreSQL with --enable-debug and
--enable-cassert, re-compile PostGIS (I assume you're using 1.3.1?) and
then use gdb to get a backtrace.

Note that there have been problems with OS X crashing in the past,
perhaps something to do with mixing fink/non-fink programs: you may find
these threads helpful:

http://postgis.refractions.net/pipermail/postgis-users/2007-August/016766.html
http://postgis.refractions.net/pipermail/postgis-users/2007-September/016924.html


HTH,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk