Jaime Casanova <systemguards@gmail.com> writes:
> On 12/15/05, Csaba Nagy <nagy@ecircle-ag.com> wrote:
>> Ok, that explains then the problem... but the index is arguably corrupt
>> in this case, with the important difference that it's not even fixable
>> by reindex...
>>
>> I guess what the OP really wants is a solution to his problem.
> MAGE was reproducing the problem in a little table that can be send
> but now tolds me that the problem in the test table disappear when a
> VACUUM was executed... is this consistent with the idea of locale
> problem?
The VACUUM might have caused the planner not to use the index anymore;
check EXPLAIN.
regards, tom lane