[postgis-devel] FW: Eureka!

[Martin Daly]

Second thoughts about posting with ~400Kb attached.  Anyone who wants
the files, please contact me off-list.

Martin

-----Original Message-----
From: Martin Daly 
Sent: 24 March 2005 11:24
To: PostGIS Development Discussion
Subject: Eureka!


I follow these steps to reproduce the crash (which is where I should
have started yesterday...):

1. Install PostGIS RC4 from MCA-s installation, choosing the Create
Database option
2. psql to the new database and run loadbang.sql, attached, then exit
psql
3. psql to the new database again, and run bang.sql, also attached,
*twice*
4. Bang!

An alternative sequence is:

1. Install PostGIS RC4 from MCA-s installation, choosing the Create
Database option
2. psql to the new database and run loadbang.sql, then run bang.sql in
the same psql session, then exit psql
3. psql to the new database again, and run bang.sql
4. Bang!

I have been completely un-installating/re-installing RC4 and
deleting/creating a database for sanity, but just using the Create
Database option also seems to work.

Two things to note are:

1. We always use GEOMETRY as the type in the geom column, because SIS is
happy mixing points, lines and polygons
2. The geometry from the sample is not "simple" (in OGC terms).  It came
direct from MIF which supports polygons with multiple outer rings, as
does SIS.  SIS can simplify the geometry, but we don't enforce this on
exporting to PostGIS.

Regards,
Martin