Re: Deadlock detected

From: Maurice Balick <balm(at)smiley(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Deadlock detected
Date: 2001-04-09 19:11:04
Message-ID: 3AD20948.6010501@smiley.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2001-04-09 19:33:05 Re: Views and default values
Previous Message will trillich 2001-04-09 19:10:38 Re: Re: information on users