Re: Corrupt Table

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: "pgsql-general" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: Corrupt Table
Date: 2000-09-14 16:23:46
Message-ID: 004b01c01e68$287ebb00$2dd260d1@arcamax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2000-09-14 16:33:44 Re: recovery of db after system crash- part II
Previous Message chris markiewicz 2000-09-14 16:23:26 RE: Error in servlet