URGENT: Index problems

Поиск
Список
Период
Сортировка
От Steve Brett
Тема URGENT: Index problems
Дата
Msg-id 9qjgpp$3h3$1@news.tht.net
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Benny Marin"
Дата:
Сообщение: BLOB
Следующее
От: "Steve Brett"
Дата:
Сообщение: Re: URGENT: Index problems - update - please help ....