Re: Deadlock detected

Поиск
Список
Период
Сортировка
От Maurice Balick
Тема Re: Deadlock detected
Дата
Msg-id 3AD20948.6010501@smiley.com
обсуждение исходный текст
Ответ на Deadlock detected  ("Brian J. France" <postgresql@firehawksystems.com>)
Список pgsql-general

Brian J. France wrote:

 >
 > BTW, on a different table I get this warning ever time I vacuum the
database. It doesn't seem to cause a problem, but didn't know how to get
rid of it.
 >
 > NOTICE:  Index <indexname>: NUMBER OF INDEX' TUPLES (214) IS NOT THE
SAME AS HEAP' (215).
 >     Recreate the index.

I had the same problem for months and just figured it out: I had a null
entry in one of the index's columns. Once I removed the null entry that
notice went away.

---Maurice


В списке pgsql-general по дате отправления:

Предыдущее
От: will trillich
Дата:
Сообщение: Re: Re: information on users
Следующее
От: will trillich
Дата:
Сообщение: Re: Views and default values