URGENT: Index problems - Mailing list pgsql-general

From Steve Brett
Subject URGENT: Index problems
Date
Msg-id 9qjgpp$3h3$1@news.tht.net
Whole thread Raw
List pgsql-general
I added a hash index to a varchar value and when i vacuumed i got the
following error:

 Index customer_ha_hash: NUMBER OF INDEX' TUPLES (9176) IS NOT THE SAME AS
HEAP' (9181).

dropping and recreating the index gave me the same error (on this index
only)

dropping the database and reimporting the data and then recreating the index
and vacuuming gave me the same error.

any ideas ? ... and does anyone know what the error means ?

thanks in advance.

Steve



pgsql-general by date:

Previous
From: "Benny Marin"
Date:
Subject: BLOB
Next
From: "Steve Brett"
Date:
Subject: Re: URGENT: Index problems - update - please help ....