[postgis-devel] CLUSTER in 8.3

[Mark Cave-Ayland]

Obe, Regina wrote:

> I just tried the below from pgAdmin III on a
> "POSTGIS="1.3.4" GEOS="3.0.3-CAPI-1.4.2" PROJ="Rel. 4.5.0, 22 Oct 2006" 
> USE_STATS PostgreSQL 8.3.5 on i686-redhat-linux-gnu, compiled by GCC gcc 
> (GCC) 4.1.2 20071124 (Red Hat 4.1.2-42)"
> 
> create temp table tmp as select st_makepoint(random(), random()) as
> the_geom from generate_series(1, 10000);
> create index tmp_geom_idx on tmp using gist (the_geom);
> analyze tmp;
> select count(*) from tmp;
> 
> Correctly returns 10000
> 
> But as I mentioned I was able to get it to fail once on this box with 
> Paul's or at least I thought I did, but can't replicate it.

Well, it is an intermittent bug - I have re-run it several times, 
restarting PostgreSQL, before I see the failure.


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063