[postgis-users] Function 60821c60 returned NULL

[Mark Cave-Ayland]

> I have a PostGIS database that is frequently thowing this error. My
> guess is that it is related to the GIS index and the number of NULL
> geometries in the table. Because of how I am using Hibernate, I insert
> the record with a NULL geometry and then update the record with the
> geometry. Has anyone else identified this error and can anyone suggest a
> fix?
> Thanks, David


Hi David,

Which versions of PostGIS are you using? (SELECT postgis_full_version()).
If it's earlier than 1.2.1, it sounds like you could be hitting the GiST
index bug documented here:
http://postgis.refractions.net/documentation/manual-svn/release_notes.html#id2692480.


HTH,

Mark.

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