[postgis-users] PostgreSQL 8.3 GiST Bug

[Mark Cave-Ayland]

Paul Ramsey wrote:
> Important information for PostGIS users! If you are on the PostgreSQL
> 8.3 series, upgrade to 8.3.5 as soon as possible, as earlier releases
> contain a GiST index bug which may cause data to occasionally not show
> up in spatially indexed searches.
> 
> This bug will only affect tables that have had records deleted and
> updated and new data inserted, so people using PostGIS in a primarily
> read-only manner won't see it, but folks with changeable data may run
> into it.
> 
> http://blog.cleverelephant.ca/2008/11/postgresql-835-important-upgrade.html
> http://www.postgresql.org/docs/8.3/static/release-8-3-5.html
> 
> Paul

Just to clarify: the bug was only introduced by another fix during the 
last set of point releases; however it was backpatched all the way to 
8.1. So the complete list of affected PostgreSQL releases is:

	8.1.14
	8.2.10
	8.3.4

ATB,

Mark.

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