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

2008-10-23 Thread Nikolay Samokhvalov
I want to say many thanks to Teodor for really quick bug fixing. Currently we are waiting for decision when official bugfix will be issued (we had to make some workarounds for production environment and thinking, what to do -- rollback to 8.3.3 or apply the patch). So the question is when 8.3.5 w

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

2008-10-22 Thread Teodor Sigaev
Fixed, the reason is the same as for http://archives.postgresql.org/pgsql-general/2008-10/msg00845.php Patch: http://archives.postgresql.org/pgsql-committers/2008-10/msg00187.php -- Teodor Sigaev E-mail: [EMAIL PROTECTED]

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

2008-10-22 Thread Teodor Sigaev
Teodor, will you look at this? Yes, Of course -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscr

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

2008-10-21 Thread Tom Lane
"Dan Fabulich" <[EMAIL PROTECTED]> 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

[BUGS] BUG #4479: Incorrect TSearch2 results when inserting after deleting

2008-10-21 Thread Dan Fabulich
The following bug has been logged online: Bug reference: 4479 Logged by: Dan Fabulich Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: OS X 10.5.5 Description:Incorrect TSearch2 results when inserting after deleting Details: Run the follo