[postgis-users] [BUGS] ERROR: XX000: function 60821C60returned NULL

[Mark Cave-Ayland]

On Wed, 2007-01-03 at 08:58 -0500, Obe, Regina wrote:
> Looks like it could be related, but not quite what I'm experiencing.  I
> am inserting all records and all coming in have NULL values. The only
> thing that's different though is that the gist index already exists and
> this table only has 50 records going into it - not the 459.  
> 
> It works for a while - like about 6 or 7 times of deleting all the
> records and readding them and then it bombs after that.
> 
> I'll try to upgrade to the latest version and see if that fixes my
> problem.
> 
> Thanks,
> Regina


Hi Regina,

Bear in mind that indexes also carry information about rows present in
previous transactions which may have been deleted since the last vacuum
which may explain the symptoms you are seeing.

I'd first try to replicate Kevin's generate_series SQL statement to see
if that crashes your PostgreSQL installation - it may help show whether
this is the same bug or a different bug. Also, I'm afraid you'll have to
compile that latest SVN snapshot from the PostGIS website since there
hasn't been a release since strk committed a fix for the bug :(


Kind regards,

Mark.