Re: Deadlock detected - Mailing list pgsql-general

From Maurice Balick
Subject Re: Deadlock detected
Date
Msg-id 3AD20948.6010501@smiley.com
Whole thread Raw
In response to Deadlock detected  ("Brian J. France" <postgresql@firehawksystems.com>)
List 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 by date:

Previous
From: will trillich
Date:
Subject: Re: Re: information on users
Next
From: will trillich
Date:
Subject: Re: Views and default values