[postgis] Server-Crash when INSERTing NULL geometries

Bernhard Reiter bernhard at intevation.de
Wed Feb 27 14:49:48 PST 2002


On Wed, Feb 27, 2002 at 01:16:26PM -0800, Dave Blasby wrote:
> > 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?

7.1.3

> 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).

That's what CVS branches are for, I guess. :)
Postgresql 7.2 has a couple of very nice features.
(Like vacuum not being as interruptive as before).

> 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.

Okay.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 248 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020227/8d3f9d0b/attachment.pgp>


More information about the postgis-users mailing list