Re: Corrupt Table - Gettting Desparate

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Cc: "Bryan White" <bryan(at)arcamax(dot)com>, "pgsql-general" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: Corrupt Table - Gettting Desparate
Date: 2000-09-15 02:25:32
Message-ID: 18493.968984732@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I said:
> What I did the last time I had to identify a corrupted tuple was to try
> SELECT tid,* FROM table LIMIT 1 OFFSET n

Er, make that "ctid" ... sorry for the error ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dale Walker 2000-09-15 05:21:52 Re: vacuum taking long time
Previous Message Hiroshi Inoue 2000-09-15 02:21:17 RE: Corrupt Table - Gettting Desparate