Re: Corrupt Table
Bryan White <bryan@arcamax.com>
From: "Bryan White" <bryan@arcamax.com>
To: "pgsql-general" <pgsql-general@postgreSQL.org>
Date: 2000-09-14T16:23:46Z
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.