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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dan Fabulich" <dan(at)fabulich(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: BUG #4479: Incorrect TSearch2 results when inserting after deleting
Date: 2008-10-21 21:32:01
Message-ID: 10204.1224624721@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Prashant 2008-10-22 05:06:14 BUG #4489: Installation error
Previous Message Kris Jurka 2008-10-21 21:18:47 Re: BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result