Re: [HACKERS] has anybody else used r-tree indexes in 6.5?

Tom Lane wrote:
>
> Jeff Hoffmann <jeff(at)remapcorp(dot)com> writes:
> > has something changed with r-tree indexes in 6.5?
> > ERROR: Operator 500 must have a restriction selectivity estimator to be
> > used in a btree index
>
> What we have here is a big OOOPS.

i guess so. the patch works fine, though, so no big deal. i thought it
was weird that i hadn't heard it come up before since it didn't seem
like something i could have caused, but you never know.

> Apparently, none of the regression tests exercise rtree indexes at all,
> else we'd have known there was a problem. Adding an rtree regression test
> seems to be strongly indicated as well...

i noticed this when i ran the regression tests and everything came out
ok, but forgot to mention it. if i recall correctly, what's actually in
the geometry regression test is pretty weak. i think it only really
tests some of the common cases, not all of the functions. it's probably
not a high priority item, though, since, judging by how long it took for
this bug to surface, there aren't a lot of people using the geometry
functions/types.