[postgis-users] Postgresql crashing while using Postgis 1.4 on Postgresql 8.4

[Emilie Laffray]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

I am writing to see if I can get help with some crash that is happening
with the latest version of Postgis.
I have tried Postgis 1.4 with 8.3 and 8.4 and every time the crash is
happening.
In the error log, I have found the following information:
2009-09-16 22:28:20 BSTLOG:  server process (PID 5748) was terminated by
exception 0xC0000005

The query that is creating that crash is the following:
SELECT	"name",
	ST_IsValid(way),
	ST_IsValidReason(way)
FROM	planet_osm_polygon
WHERE	osm_id < 0
	AND NOT ST_IsValid(way)

I am currently working on an import into OpenStreetmap to perform some
overlap calculation, but I realized that we had some problems with
invalid geometries due to the import program and due to input geometries
being wrong.
The goal of that query and installing postgis 1.4 was to get the ids of
the faulty geometries. Some can be cleaned with the clean geometry
function, some have to be fixed manually.

I hope someone can help me here. I will provide any help on trying to
resolve that issue.

Emilie Laffray
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)

iEUEARECAAYFAkqxWqsACgkQ7H1ne0ugLJnzwwCcDsUNCyMhp/1MhZz75lDm+Tvh
N/kAl0g1QPLlukMvn9ZG5Vcl2TcjsxM=
=B3w4
-----END PGP SIGNATURE-----