Re: BUG #4479: Incorrect TSearch2 results when inserting after deleting

"Dan Fabulich" <dan@fabulich.com> writes:
> Description:        Incorrect TSearch2 results when inserting after deleting

> EXPECTED: The last two SELECT statements should return the same results (1
> row)
> ACTUAL: The final SELECT statement returns 0 results.  The SELECT statement
> just before it returns 1 result.

Hmm.  I can reproduce this with the given script on 8.3 current, but
*not* in CVS HEAD.  Also, the script results in an indexscan plan,
but if you set enable_indexscan off (resulting in a bitmap scan of the
same index), the correct result is returned.  Fascinating.

Teodor, will you look at this?

            regards, tom lane