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

From Bruce Momjian
Subject Re: [HACKERS] has anybody else used r-tree indexes in 6.5?
Date
Msg-id 199906190104.VAA07610@candle.pha.pa.us
Whole thread Raw
In response to RE: [HACKERS] has anybody else used r-tree indexes in 6.5?  ("Stupor Genius" <stuporg@erols.com>)
List pgsql-hackers
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> > 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.

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@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

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