Re: Detecting corrupted pages earlier

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 Inoue
	http://www.geocities.jp/inocchichichi/psqlodbc/