Re: Detecting corrupted pages earlier

Tom Lane wrote:
>
> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> writes:
> > Tom Lane wrote:
> >> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)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 Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/