[postgis-devel] error with GIST indexes with NULLs

Mark Cave-Ayland mark.cave-ayland at ilande.co.uk
Fri Dec 15 09:46:28 PST 2006

On Fri, 2006-12-15 at 17:00 +0100, strk at refractions.net wrote:

Hi strk,

> On Fri, Dec 15, 2006 at 07:36:09AM +0000, Mark Cave-Ayland wrote:
> > Confirmed. I've had a quick look at this with a debugger, and it appears
> > that the culprit is BOX2D_union calling PG_RETURN_NULL, which causes
> > DirectFunctionCall2 to error out in fmgr.c.
> BOX2D_union is likely *always* returning NULL. We're talking about 459
> success and 1 failure ...

AIUI the GiST penalty clause is called to determine into which subtree
it is the least expensive to insert into - so my guess is that the
insertion is falling over just after the first page split, but I don't
have enough time to investigate at the moment :(

Kind regards,


More information about the postgis-devel mailing list