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

Поиск
Список
Период
Сортировка
От Stupor Genius
Тема RE: [HACKERS] has anybody else used r-tree indexes in 6.5?
Дата
Msg-id 000001beb9ea$7bc5d0c0$7f98accf@darren
обсуждение исходный текст
Ответ на Re: [HACKERS] has anybody else used r-tree indexes in 6.5?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] has anybody else used r-tree indexes in 6.5?  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
> Jeff Hoffmann <jeff@remapcorp.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.

Darren



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] has anybody else used r-tree indexes in 6.5?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] has anybody else used r-tree indexes in 6.5?