[postgis-users] [BUGS] ERROR: XX000: function 60821C60returnedNULL

[Obe, Regina]

Yes that does give the same exact error I am getting so that must be it.


Thanks,
Regina 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Mark
Cave-Ayland
Sent: Wednesday, January 03, 2007 9:10 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] [BUGS] ERROR: XX000: function
60821C60returnedNULL

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.


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.