Re: Planning to force reindex of hash indexes

Mendola Gaetano wrote:
> "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > "Mendola Gaetano" <mendola(at)bigfoot(dot)com> writes:
> > > "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > >> I've found a number of infelicities in the hash index code that can't
> be
> > >> fixed without an on-disk format change.
> >
> > > How can we avoid this kind of mess for the future ?
> >
> > Build a time machine, go back fifteen years, wave a magic wand to
> > increase the IQ levels of the Berkeley grad students?
>
> :-)
>
> > Sometimes we just have to change bad decisions, that's all.
>
> I don't know how much old is the code incriminated but I mean
> there is no way to improve the code approved ?

I am not sure what you are asking, but the bug existed long before we
got it from Berkeley, and even then, it might have slipped by us anyway
without our noticing anyway --- we are never going to be perfect.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073