Re: [HACKERS] major flaw in 6.5beta1??? (UPDATE/INSERT waiting)

Dirk Lutzebaeck writes:
> Tom Lane writes:
> > Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com> writes:
> > > cs=> select envelope from recipient where envelope=510349;
> > > [ returns a tuple that obviously fails the WHERE condition ]
> >
> > Yipes. Do you have an index on the envelope field, and if so is
> > it being used for this query? (Use EXPLAIN to check.) My guess
> > is that the index is corrupted. Dropping and recreating the index
> > would probably set things right.
>
> Yes, thanks, recreating the index cures the problem.

Here is some more info: the automatic vacuum tonight gave the
following errors:

vacuum analyze;
NOTICE: Index recipient_oid_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_addr_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_mem_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_env_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_oid_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_addr_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_mem_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
NOTICE: Index recipient_env_index: NUMBER OF INDEX' TUPLES (1474) IS NOT THE SAME AS HEAP' (1473)
VACUUM