Postgres Pro
Downloads
Home   >   mailing lists

Re: index scan leads to result that is different from sec scan after upgrading to 8.3.4 - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: index scan leads to result that is different from sec scan after upgrading to 8.3.4
Date
Msg-id c3a7de1f0810200707g25b7c890r552a83f15af580ad@mail.gmail.com
Whole thread Raw
In response to Re: index scan leads to result that is different from sec scan after upgrading to 8.3.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
> "Sergey Konoplev" <gray.ru@gmail.com> writes:
>> Will somebody explain what has happened and how to solve the problem please?
>
> Apparently you've found a bug in either btree_gist or the core GIST
> code.  Can you put together a self-contained test case?
>

Ok, I will try.

One more thing I want to mention is that we have fixed (temporary) the
problem by recreating the index without "where" clause so it is not
used by the queries now.

--
Regards,
Sergey Konoplev
--
PostgreSQL articles in english & russian
http://gray-hemp.blogspot.com/search/label/postgresql/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: index scan leads to result that is different from sec scan after upgrading to 8.3.4
Next
From: Lennin Caro
Date:
Subject: Re: removing a portion of text