"Dan Fabulich" <dan(at)fabulich(dot)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