Re: Detecting corrupted pages earlier - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: Detecting corrupted pages earlier
Date
Msg-id 3E5436F4.429FD4C1@tpf.co.jp
Whole thread Raw
In response to Detecting corrupted pages earlier  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Detecting corrupted pages earlier  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > Tom Lane wrote:
> >> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> >>> Is there a way to make our way around the pages ?
> >>
> >> If the header is corrupt, I don't think so.
> 
> > What I asked is how to read all other sane pages.
> 
> Oh, I see.  You can do "SELECT ... LIMIT n" to get the rows before the
> broken page, but there's no way to get the ones after it.  My proposal
> won't make this worse, but it won't make it any better either.  Do you
> have an idea how to get the rows after the broken page?

How about adding a new option to skip corrupted pages ?

regards,
Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: request for sql3 compliance for the update command
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: request for sql3 compliance for the update command