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

[Obe, Regina]

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

-----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 4:08 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] [BUGS] ERROR: XX000: function
60821C60returned NULL

On Tue, 2007-01-02 at 15:52 -0500, Obe, Regina wrote:
> I asked the pgsql-bugs - (there comments below) and they think its a 
> PostGIS issue.  I do have a gist index on the_point field.  I think it

> does cause a core dump since if I am connected via PgAdmin immediately

> after doing a load, my connection is broken and I have to connect
again.
> I forgot to mention I update the_point field after the data is loaded,

> but during load the_point is null and again I suspect it has something

> to do with the frequency of my load since the other tables are fine 
> (and this is fine for a while and then it starts happening).
> 
> Thanks,
> Regina


Hi Regina,

Do you have any NULL geometries in your point field? It could be that
you are finding this bug:
http://postgis.refractions.net/pipermail/postgis-devel/2006-December/002
421.html. Could you try applying the patch mentioned in the thread and
see whether this helps you?


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.