Re: [GENERAL] database corruption? - Mailing list pgsql-general

From Ed Loehr
Subject Re: [GENERAL] database corruption?
Date
Msg-id 38C03CCC.C4AA5DA9@austin.rr.com
Whole thread Raw
In response to database corruption?  (Chris Jones <cjones@rightnowtech.com>)
List pgsql-general
Chris Jones wrote:
>
> NOTICE:  Index error_interface_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS HEAP' (226765)
> NOTICE:  Index error_ewhen_idx: NUMBER OF INDEX' TUPLES (226766) IS NOT THE SAME AS HEAP' (226765)

Hope this was not already answered...

I believe it means that the indices "error_interface_idx" and
error_ewhen_idx" have become corrupted.  The fix is to drop and
rebuild them.

Cheers,
Ed Loehr

pgsql-general by date:

Previous
From: Jason Vasquez
Date:
Subject: Nested tables
Next
From: Ed Loehr
Date:
Subject: Re: [GENERAL] Nested tables