[postgis] Server-Crash when INSERTing NULL geometries

[Dave Blasby]

> Can you be more specific about what needs to be done to
> either extract a patch for 7.1.3 or adapt postgis for 7,2?

What version of postgresql are you using?

To adapt to 7.2, all the GiST support functions will need to be
changed.  They're in postgis_ops.c and have names like "ggeomtry..."
(note the double 'g').  I based the postgis index support functions as
closely as possible to the oleg and teodor's rtree sample code so it
would be easy to upgrade if the GiST index was changed.

Unfortunately, the changes are quite major, but you should still be able
to look at their 7.1 rtree code vs. my postgis code and reconstruct new
7.2 postgis geometry functions by looking at their 7.2 rtree code as a
guide.  

I looked at it and thought it would take 3 days to a week to fix, but
the main problem is it would cause a split in the postgis code base (one
version for 7.1 and another for 7.2).


> > You might want to ensure that you have 7.1.2 and do a "vacuum analyze"
> > before building the index.  (see teodor and oleg's page for Tue May 15).
> 
> I do not fully understand your last remark.

The website says a workaround is a "vacuum analyse".  This command helps
to get rid of redundant nodes in indexes (plus a bunch of other stuff). 
Its worth a try to (1) upload data into table (2) "vacuum analyse" (3)
build index (4) "vacuum analyse"  and see if it helps.


dave

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Tiny Wireless Camera under $80!
Order Now! FREE VCR Commander!
Click Here - Only 1 Day Left!
http://us.click.yahoo.com/nuyOHD/7.PDAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/