URGENT: Index problems

From: "Steve Brett" <steve(dot)brett(at)e-mis(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: URGENT: Index problems
Date: 2001-10-17 08:48:09
Message-ID: 9qjgpp$3h3$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Brett 2001-10-17 09:20:05 Re: URGENT: Index problems
Previous Message Ashley @ Turton 2001-10-17 08:24:42 Blank SQL insert statements