> Bruce Momjian wrote:
> >
> > This new patch uses scankeys instead of throwing the indexqual to the
> > executor. This is probably more efficient, but I am not sure about the
> > other ramifications. It still fails.
>
> This wouldn't handle functional indices in OR...
>
> So, I added indexqualorig list to the IndexScan node:
>
> indexqual = fix_indxqual_references (indexqualorig)
>
> - indxqualorig' Var-s references heap tuple...
>
> Regression tests are ok.
> Patch made for CURRENT tree - let me know if there will
> be problems with 6.4...
>
> It's better to gmake clean in backend dir...
>
> Patch also fixes EXPLAIN for indices in OR: all indices
> used are explained now.
>
> Vadim
Thanks very much. I have applied this to the stable branch, because
without it, we get backend crashes.
-- 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