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

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> > 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
> >
> > ...
> >
> > The right fix would be to put in an appropriate selectivity estimator,
> > but we can't do that as a 6.5.* patch because changing pg_operator
> > requires an initdb. It will have to wait for 6.6.
>
> Would it possible to write an sql script to put in the changes?
>
> Seems it should be possible to do this for any non-code changes
> that affect the system tables.

Yes, we could, and have in the past had SQL scripts that are run as part
of the upgrade, but this fix is easier to do in C because it doesn't
require that difficult step for upgraders.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026