Jaime Casanova <systemguards@xxxxxxxxx> writes: > On 12/15/05, Csaba Nagy <nagy@xxxxxxxxxxxxxx> 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
