[postgis-devel] error with GIST indexes with NULLs

[strk at refractions.net]

On Fri, Dec 15, 2006 at 07:36:09AM +0000, Mark Cave-Ayland wrote:
> On Thu, 2006-12-14 at 10:59 -0800, Kevin Neufeld wrote:
> > Hi all,
> > 
> > Apparently, in PostgreSQL 8.2, one cannot have more than 459 null 
> > geometries in a spatial table before the gist index creation fails. Has 
> > anyone else seen this?
> > Note: this test works fine with 8.1.

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

--strk;