Re: Corrupt Table - Mailing list pgsql-general

From Bryan White
Subject Re: Corrupt Table
Date
Msg-id 004b01c01e68$287ebb00$2dd260d1@arcamax.com
Whole thread Raw
In response to Corrupt Table  ("Bryan White" <bryan@arcamax.com>)
List pgsql-general
Here is a follow up.  I did a hex/ascii dump of the 3 bad tuples.  In the
dump I could pick out an email address.  This is an indexed field.  I did a
select on each of them in the live database.  The 1st and 3rd were not
found.  The second worked ok if I only selected the customer id (an int4 and
the first field in the record).  The custid reported seems to be nonsense.
The backend crashed if I selected the whole record.


pgsql-general by date:

Previous
From: "chris markiewicz"
Date:
Subject: RE: Error in servlet
Next
From: Chris Sterling
Date:
Subject: Upgrading from 6.3.2 to 7.0.2