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

From Stupor Genius
Subject RE: [HACKERS] has anybody else used r-tree indexes in 6.5?
Date
Msg-id 000001beb9ea$7bc5d0c0$7f98accf@darren
Whole thread Raw
In response to Re: [HACKERS] has anybody else used r-tree indexes in 6.5?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] has anybody else used r-tree indexes in 6.5?
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] has anybody else used r-tree indexes in 6.5?
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] has anybody else used r-tree indexes in 6.5?