[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